Export DBF to XLS (Excel)
With DBF Viewer 2000 you can export dbf files to xls (Excel) from GUI or from the command line
To
export a dbf file to XLS (Excel) format, open
File | Save as/Export menu,
and select file type: XLS.
"Export DBF to XLS"
dialog box opens. Select the fields to be exported and specify
their order using up and down arrows.
DBF Viewer 2000 allows you export memo fields (from .fpt/.dbt files) to XLS format.
To
export large memo fields, set on option "XML-based"
Export
dbf to XLS from the command line:
dbview.exe dbffile /EXPORT:xlsfile [/XML]
[/FILTER|/REVERSE| /COLUMNS | /FROMRECORD]
Example 1, simple export dbf to xls
c:\Program Files\DBF Viewer 2000\dbview.exe
sample.dbf /EXPORT:sample.xls
Example 2, export dbf to xls in reverse order
c:\Program Files\DBF Viewer 2000\dbview.exe
sample.dbf /EXPORT:sample.xls /REVERSE
Example 3, export dbf to xls from record #100
c:\Program Files\DBF Viewer 2000\dbview.exe
sample.dbf /EXPORT:sample.xls /FROMRECORD:1000
Example 4, export dbf to xls as xml based
c:\Program Files\DBF Viewer 2000\dbview.exe
sample.dbf /EXPORT:sample.xls /XML
See
also: DBF to CSV, DBF to XML, DBF to SQL, command line options,
Filtering records in dbf
file
|