DBF Viewer 2000
DBF Viewer 2000 Online Help Prev Page Prev Page
Introduction
Hotkeys
Command line options
Working with dbf files
Opening DBF files
Creating New DBF file
Modifying dbf file structure
Viewing statistics
Import/Append records
Save As/Export
Working with records
Adding records
Editing records
Deleting records
Replacing records
Filling records
Sorting records
Searching and Filtering
Searching by criteria
Filtering records
How To
Export DBF to CSV
Export DBF to XLS (Excel)
Export DBF to XML
Export DBF to SQL
Excel to DBF
Commands
File
Edit
View
Tools
Options
Information
Support
How to purchase
Download DBF Viewer and Editor Top  Previous  Next

Export DBF to Excel

Download

With DBF Viewer 2000 you can export dbf to Excel (XLS, XLSX) 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 or XLSX (Excel 2003-2017).

"Export DBF to XLS" dialog box opens. Select the fields to be exported and specify their order using up and down arrows.

Export dbf to xls (excel) screenshot

DBF Viewer 2000 allows you export memo fields (from .fpt/.dbt files) to XLS/XLSX format.

To export large memo fields, set on option "XML-based"

 

DBF to Excel exporting via command line

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

Examples:

Simple export DBF to XLS

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

Export DBF to XLSX format

"c:\Program Files\DBF Viewer 2000\dbview.exe" sample.dbf /EXPORT:mytable.xlsx

Export dbf to Excel with columns selection

"c:\Program Files\DBF Viewer 2000\dbview.exe" sample.dbf /EXPORT:mytable.xls /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 XLSX from record #100

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

Export dbf to xls as xml based

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

Export with sorting

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

Export DBF to XLS with Wide filter

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

 

Free Download DBF Viewer and Editor

Updated Wed, 30 Aug 2017

See also: DBF to CSV, DBF to XML, Excel to DBF importing, DBF to SQL, command line options, Filtering records in dbf file

Back to DBF Viewer 2000 Home

Copyright © HiBase Group, 2002-2017