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 Text
Export DBF to XLS (Excel)
Export DBF to XML
Export DBF to SQL
Export DBF to MySQL
Commands
File
Edit
View
Tools
Options
Information
Support
How to purchase
Top  Previous  Next

Excel to DBF

Download

When you have data for several years saved as Excel documents, transferring all the records to a DBF file is a pain. First of all, automatic exporting that Excel offers is far from ideal. And Excel 2013 cannot save dBase III and IV file format at all, it only reads them. Second, the complex structure of data often does not fit into the structure of a DBF file without manual adjustment. Third, the performance is not what you’d expect from a software giant.

The solution? Try DBF Viewer 2000 to import data from Excel to DBF. The tool works faster, reads any XLS and XLSX documents and promptly imports information from them to the selected DBF file.

Excel to DBF importing

Once you open the Excel file you want to import records from in DBF Viewer 2000, it scans the file and presents you a quick preview of all sheets in the document. The program detects field types and lengths automatically.

In fact, the process is automated almost completely, so there’re no many options left. The “First row” option allows you to tell the program where the actual data start. This is handy, when the XLS document has a complex header.
And the “Remove all records” option allows you to remove old records from file.

Once, you are done, click OK and the data are imported to DBF.

Excel to DBF importing via command line

"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" /APPEND:file1.dbf,file2.xlsx [/ZAP]

Examples:

Simple importing

c:\Program Files (x86)\DBF Viewer 2000\dbview.exe /APPEND:file1.dbf,src.xlsx

Importing with removing old records

"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" /APPEND:file1.dbf,src.xlsx /ZAP

Free Download DBF Viewer and Editor

Updated Wed, 22 Nov 2017

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

Back to DBF Viewer 2000 Home

Copyright © HiBase Group, 2002-2017