Export DBF to XLS

To export a dbf file to XLS (Excel) format, open File | Save as/Export menu, and select file type: XLS.

Export to 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 filelds (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]

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

export with option xml-based (Excel 2003)

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