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
Commands
File
Edit
View
Tools
Options
Information
Support
How to purchase
Free download DBF Viewer and DBF Editor Top  Previous  Next

Working with DBF Files via Command Line

You can run DBF Viewer in MS-DOS prompt or use from .BAT files or run this commands from other applications.

Free Download DBF Viewer and Editor
(30 Aug 2017)

If you need Additional/Custom command line options, please Contact us.

DBF Viewer Command Line:

"c:\Program Files\DBF Viewer 2000\dbview.exe" file.dbf [/EXPORT | /EXPORTSTATS | /APPEND | /FILL | /REPLACE | /DELETEDUPS [/KEEPLAST] | /RECALL | /PACK | /EXPORTSTRUCT | /DELETE:N,N | /RENAME:fld,newfld]

(Note: For Windows 64bit full path: "c:\Program Files (x86)\DBF Viewer 2000\dbview.exe")

Open dbf file from the command line

"c:\Program Files\DBF Viewer 2000\dbview.exe" file.dbf [/RO |/OEM /ANSI | /SHARED]

 

Start without Open dialog

"c:\Program Files\DBF Viewer 2000\dbview.exe" /NOOPEN

Run DBF Viewer 2000 in read only mode

"c:\Program Files\DBF Viewer 2000\dbview.exe" file.dbf /RO

"c:\Program Files\DBF Viewer 2000\dbview.exe" /RO

 

Run in shared mode

"c:\Program Files\DBF Viewer 2000\dbview.exe" file.dbf /SHARED

"c:\Program Files\DBF Viewer 2000\dbview.exe" /SHARED

Export DBF file structure to Text/CSV file

"c:\Program Files\DBF Viewer 2000\dbview.exe" mybase.dbf /exportstruct:struct.txt

Use OEM characters

"c:\Program Files\DBF Viewer 2000\dbview.exe" file.dbf /OEM

"c:\Program Files\DBF Viewer 2000\dbview.exe" /OEM

Use ANSI characters

"c:\Program Files\DBF Viewer 2000\dbview.exe" file.dbf /ANSI

"c:\Program Files\DBF Viewer 2000\dbview.exe" /ANSI

 

Append/Import records from DBF, TXT, CSV, Excel(XLS, XLSX, XLSM) and Paradox files

 

Examples:

Append records from other dbf file:

"c:\Program Files\DBF Viewer 2000\dbview.exe" /APPEND:file1.dbf,file2.dbf

 

Import records from XLSX file to dbf file:

"c:\Program Files\DBF Viewer 2000\dbview.exe" /APPEND:file1.dbf,file2.xlsx

Import records from CSV file :

"c:\Program Files\DBF Viewer 2000\dbview.exe" /APPEND:file1.dbf,file2.csv /SEP;

or "c:\Program Files\DBF Viewer 2000\dbview.exe" /APPEND:file1.dbf,file2.csv /SEP; /ZAP

 

where /SEP: - use ';' as delimiter, /ZAP - remove all records before append.

 

Open DBF file with filter

 

"c:\Program Files\DBF Viewer 2000\dbview.exe" myfile.dbf /FILTER:myfilterfile

 

filter file format:

 

Field name:Value|Expression

 

Export DBF to other formats

"c:\Program Files\DBF Viewer 2000\dbview.exe" file1.dbf /EXPORT:outfile.ext [options]

The command export records from file1.dbf to file1.ext, where ext - (txt, csv, dbf, sql, xml, xls, xlsx, html, rtf, sdf)

 

options:

/SEP set delimiter (txt/csv format only)

/SKIPD skip deleted records

/SKIPM skip memo fields

/FILTER set filter

syntax: /FILTER:filterfile

each line in the filter file: fieldname:value | expression

/WFILTER set Wide filter

syntax: /WFILTER:value

 

/COLUMNS select columns

syntax: /COLUMNS:field1,field2

/SORTBY:field Sort by field

 

Export dbf to csv format:

"c:\Program Files\DBF Viewer 2000\dbview.exe" file1.dbf /EXPORT:file2.csv [/SEPx | /SEPTAB | /SEPPIPE | /SEPSPACE | /FILTER| /WFILTER | /UTF8]

where x delimiter

 

"c:\Program Files\DBF Viewer 2000\dbview.exe" file1.dbf /EXPORT:file2.txt /SEP: /HDR

/HDR - for put the fields names in first line.

 

dbview.exe sample.dbf /EXPORT:sample.txt /COLUMNS:NAME,STREET /SEPTAB

dbview.exe sample.dbf /EXPORT:sample.txt /COLUMNS:NAME,STREET /SEPTAB /WFILTER:NY

where: export only columns NAME and STREET, TAB delimiter

 

/SEPPIPE - use pipe as delimiter

/SEPSPACE - use space as delimiter

 

Export dbf to dBase III format

"c:\Program Files\DBF Viewer 2000\dbview.exe" file1.dbf /EXPORT:file2.dbf /DBASE3

 

export dbf file to visual foxpro format

"c:\Program Files\DBF Viewer 2000\dbview.exe" file1.dbf /EXPORT:file2.dbf /VFP

 

Export dbf to sql format:

"c:\Program Files\DBF Viewer 2000\dbview.exe" file1.dbf /EXPORT:file2.sql [/mysql | /oracle | /mssql | /postgresql] [/NOCREATESTATEMENT]

 

/NOCREATESTATEMENT - allows you generate sql script without CREATE TABLE statement.

 

export dbf to xlsx format:

"c:\Program Files\DBF Viewer 2000\dbview.exe" file1.dbf /EXPORT:file2.xlsx /WFILTER:NY

export dbf to xls format:

"c:\Program Files\DBF Viewer 2000\dbview.exe" file1.dbf /EXPORT:file2.xls

 

export dbf to xls as xml-based format (since Excel 2003)

Allows you export memo fields to excel.

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

 

See also: Export DBF to XLS, Export DBF to CSV, Export DBF to XML, Export DBF to SQL

Replace records in dbf file

 

"c:\Program Files\DBF Viewer 2000\dbview.exe" /REPLACE:fieldname:oldvalue:newvalue [/substr /case]

 

/substr - replace substring

/case   - case sensitive comparison

 

example:

"c:\Program Files\DBF Viewer 2000\dbview.exe" base.dbf /REPLACE:name:Tom:Peter

 

Fill records in dbf file

 

"c:\Program Files\DBF Viewer 2000\dbview.exe" /FILL:fieldname:value

example:

"c:\Program Files\DBF Viewer 2000\dbview.exe" base.dbf /FILL:STATUS:OK

Delete duplicates from dbf file

 

"c:\Program Files\DBF Viewer 2000\dbview.exe" base.dbf /DELETEDUPS

 

Auto open last dbf file and show last record in Record View mode

 

"c:\Program Files\DBF Viewer 2000\dbview.exe" /GOLASTRECORD

 

Fix dbf file with incorrect size

 

"c:\Program Files\DBF Viewer 2000\dbview.exe" file.dbf /FIX

 

or with wildcards

"c:\Program Files\DBF Viewer 2000\dbview.exe" *.dbf /FIX

 

 

Pack DBF file

 

"c:\Program Files\DBF Viewer 2000\dbview.exe" file.dbf /PACK

or with wildcards

"c:\Program Files\DBF Viewer 2000\dbview.exe" *.dbf /PACK

 

Free Download DBF Viewer and Editor

Updated Wed, 22 Nov 2017

 

Back to DBF Viewer 2000 Home

 

Copyright © HiBase Group, 2002-2017