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:

"c:\Program Files\DBF Viewer 2000\dbview.exe" file.dbf /EXPORT:file.xls | files.xlsx [/XML] [/FILTER|/REVERSE| /COLUMNS | /FROMRECORD | /sheetasfilename]

Simple export dbf to xls

c:\Program Files\DBF Viewer 2000\dbview.exe sample.dbf  /EXPORT:sample.xls

"c:\Program Files\DBF Viewer 2000\dbview.exe" sample.dbf /EXPORT:sample.csv /COLUMNS:ZIP,NAME

Export dbf to xls in reverse order

c:\Program Files\DBF Viewer 2000\dbview.exe sample.dbf  /EXPORT:sample.xls /REVERSE

Export dbf to xls from record #100

c:\Program Files\DBF Viewer 2000\dbview.exe sample.dbf  /EXPORT:sample.xls /FROMRECORD:1000

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