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
Delete duplicates
DBF File Optimization
Commands
File
Edit
View
Tools
Options
Information
Support
How to purchase
Top  Previous  Next

Merge Two DBF Files into One


DOWNLOAD
for FREE

First of all, run DBF Viewer 2000 and open the DBF file you want to add data to (destination). Then open the File menu and select Import / Append or press the Shift-A keyboard shortcut. This will open the file dialog:

select dbf file window

Select the file you want to merge with the currently opened DBF file and click Open.

DBF Viewer 2000 will open the selected DBF file and display the Append dialog where you can preview the contents of the selected file and adjust importing options.

append dialog

There are two options here. The "First row" option allows you to set where the data from the source DBF will be appended to the destination DBF. Zero means data are appended after the last record in the destination DBF.

The "Remove all records" option deletes all records in the destination DBF file before merging. Technically, this means you replace contents of one DBF file with contents of another one.

The "Command line" button displays the command line you can execute later to do the same merging as this one.

When you are done, click OK to merge two DBF files together.

Sometimes after merging DBF files the resulting dataset may contain duplicate records. To remove duplicates, use the Tools | Delete Duplicates menu. DBF Viewer 2000 will scan the records and will automatically remove identical ones.

Merge via Command Line

"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" /APPEND:file.dbf,file | path

Merge two files

"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" /APPEND:first.dbf,second.dbf

Merge multiple files

"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" /APPEND:file.dbf,"z:\mybase\*.dbf"


DOWNLOAD
for FREE

Updated Fri, 02 Nov 2018

See also: DBF File format, DBF File Optimization, DBF to XLS (Excel), DBF to SQL, DBF to CSV, DBF Repair Tool, Filtering recordsSorting records in dbf file, Command line options

Back to DBF Viewer 2000 Home

Page top |  Copyright © HiBase Group, 2002-2018   gplus