Standard

  • current build 1.15 (10.09.2019)
  • usage under pure DOS (on demand) / WIN32/64 or *NIX
  • internal precision 80 Bit
  • conversion done in user codepage (mostly CP850 DOS LATIN 1)
  • converts Open Access II / III and IV databases
  • converts .DF to DBF/DBT/CSV/DIF
  • option to write FLOAT as character field (DBASE)
  • converts .DF even if .IF / .MF is missing
  • converts MEMO to .DBT or .CSV with escaping
  • converts huge databases (1 mio) within seconds
  • import from .CSV (with header field) to OA4 (same fieldnames) and
  • automatic BOM (Byte-Order-Mark) conversion to OEM-CP and custom
  • separator.
  • import .DIF to OA4

Advanced

  • undelete all deleted entries from database (in case of recovery)
  • full decryption of .CND files (extract .ARR/.BAT/.TXT files/paths from CND
  • back to relative directories)
  • .IF repair (250 T sets with 12 indexes in less then 60 seconds)
  • full decryption of password protected SMK/DF/IF/MF
  • and full password reset without entering current password !
  • SMK/DF/IF/MF files will be fully new rewritten without password.
  • added function to fix corrupted external field table in SMK (fix DB30131:
  • Maximum count of external fields). Advanced Converter can repair and rewrite the SMK.
Usage:

Usage: oa4db <-c|-d|-i[r]|-p|-f|-o|-u|-r> [-n|-m|-t] [-c] [-x[fld1,..]]
<OA4 DB name> [Output DBF file]
 
-c      convert to .CSV
-cr[s]  import from .CSV [s = separator see examples]
-d      convert to .DBF
-i      convert to .DIF
-ir     import from .DIF to .DF

-o      decrypt .CND
-p      remove password and decrypt
-u      undelete all deleted datasets
-r      repair and rebuild IF (delete .IF before)
-f      fix corrupted external field table in SMK
 
Memo handling:
 
-n      do not handle MEMO (ignore)
-m      write MEMO to DBASE memo file (only valid for -d)
-t      write MEMO as text field (default)
-c      write float as character field (only valid for -d)
-x      exclude the specified columns in export
 
[Output DBF File] Dbase file to create. 
If not set, it is OA4DBname.CSV/.DBF
 
Examples:      
oa4db.exe -d database output.dbf
oa4db.exe -d -m database output.dbf
oa4db.exe -d -c database output.dbf
oa4db.exe -c database output.csv
oa4db.exe -c -x field1,field2,field5 database output.csv
oa4db.exe -p database
oa4db.exe -f smkfilename
oa4db.exe -cr database file.csv
oa4db.exe -cr\t database file.csv

The seperator char can be appended to -cr i.e.: -cr\t for tab 
or  -cr, for comma. Default is ; seperator.