DBF to Excel Exporting

Exporting DBF to Excel has a lot of potential uses. Creating Excel reports based on information stored in a database; converting older DBF files to the more easily readable XLSX format; migrating from legacy information systems based on DBF databases to other platforms; using Excel as an intermediate checkpoint to convert DBF to other database formats.

To export a DBF file to an Excel spreadsheet, follow these steps:

Step 1. Run DBF Viewer 2000 and open the DBF file you want to export to Excel.

Step 2. Select File | Save as/Export menu command

Menu Save As

Step 3. Select file type: XLS or XLSX (Excel 2003-2023) and click "OK"

Save As Dialog

Step 4. "Export to Excel" dialog box opens.

DBF to Excel screenshot

Here, you can adjust the exporting parameters, namely:

  • Select what fields from the original DBF will be transferred to the output Excel document
  • Set filter to export only records that match specific criteria (like SALARY >= 5000 or FNAME contains "John")
  • Export records in the reverse order
  • Export a specified range of records

When you are done, click the OK button to start exporting. DBF Viewer 2000 starts conversion and shortly you end up with your DBF file successfully converted to Excel. If you have selected the Open after export option, Microsoft Excel starts automatically when the conversion finishes, with the resulting XLSX file already opened.

DOWNLOAD
for FREE

DBF to Excel Command Line

"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" file.dbf /EXPORT:file.xls | file.xlsx [/XML] [/FILTER | /REVERSE| /COLUMNS | /FROMRECORD | /SORTBY [/DESC] | /SHEETASFILENAME | /NOHDR | /LOG]

Examples:

Simple export DBF to XLS

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

Export DBF to XLSX format

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

Export with Columns Selection

"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" sample.dbf /EXPORT:mytable.xls /COLUMNS:ZIP,NAME

Export DBF to XLS in reverse order

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

Export DBF to XLSX from record #100

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

Export dbf to xls as xml based

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

Export with sorting

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

Export with Filter command by Name

c:\Program Files (x86)\DBF Viewer 2000\dbview.exe sample.dbf /EXPORT:table.xls /FILTER2:Name:Jim

Export DBF to XLS with Wide filter

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

Export without header

c:\Program Files (x86)\DBF Viewer 2000\dbview.exe sample.dbf /EXPORT:table.xls /NOHDR

Set Sheet Name as File name

c:\Program Files (x86)\DBF Viewer 2000\dbview.exe sample.dbf /EXPORT:mytable.xlsx /sheetasfilename

Export with Log file generation

c:\Program Files (x86)\DBF Viewer 2000\dbview.exe sample.dbf /EXPORT:mytable.xlsx /LOG:d:\Logs\myexport.txt

Set Range for fields

c:\Program Files (x86)\DBF Viewer 2000\dbview.exe sample.dbf /EXPORT:mytable.xlsx /STARTFLD:2 /ENDFLD:5

Do you need more options for Excel format ?

Please, contact us by E-mail: support@dbf2002.com or by On-line form.

DOWNLOAD NOW

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