Export to DBF format (Db2Dbf)     

Db2Dbf allows you to export all the data from one or all tables in a database
in DBF format. Db2Dbf writes the output by default to 'table.dbf' unless you
specify with the '-o' option a different output file.
Db2Dbf also create the DBF Memo DBT file "table.dbt" connected to "table.dbf"
If you don't specify a table with the "-t" option Db2Dbf will export all tables.
Db2Dbf writes all diagnostics to a log file "logs/yyyymmdd/Db2Dbf.log"
The exported DBF data can be transmitted to other clients or imported to any
other database with the DbLoad utility.
Note that In demo mode up to 100 records can be exported.

You can view your DBF data with the DbTkXml Database Explorer

-usage: Db2Dbf [-sn] [-d{db}] [-o{out}] [-t{tab}]
-d = DATABASE: Specify database input file (default Sample.mdb)
-o = OUTPUT  : Specify output filename (default Table.{xml|dbf|txt|csv|htm})
                 -o STDOUT writes directly to standard output not a file
-t = TABLE   : Specify Table name (default is all tables)
                 or table number ('#3' = 3rd table)(Not needed from DBF)
-s = SILENT  : Dont show diagnostics (XX Records written..)
-n = NOHEADER: Dont write DTD (XML), header line (TXT, CSV, HTML)

Db2dbf -d sample.mdb -t Employees -o emp.dbf
9 'Employees' Record(s) written to 'emp.dbf'

Exports all data from the " Employees" table from database "Sample.mdb".
The output is written to "emp.DBF" and the DBF Memo DBT file to "emp.DBT"

Example DBF Output (emp.dbf)

If you run this command on Feb 18th, 2001 the logfile would be created in:
INIT    |13:35:03.438 |====== Opening c:/dbtkxml/logs/20010218/Db2Dbf.log ======
DbTkXml |13:35:03.549 |ExecCmd: opendb Sample.mdb
DbTkXml |13:35:03.599 |ExecCmd: table Employees
DbTkXml |13:35:03.619 |ExecCmd: DBFEXPORT emp.DBF
DbTkXml |13:35:03.639 |9 'Employees' Record(s) written to 'emp.DBF'

Table,Column,Field,Record,Index,Query,External Data,Save As,merge,synchronize,explorer,
command,line,batch scipts, shareware