Working with DBF Files from the command line

Open dbf file from the command line

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

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

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 or TXT files

examples:

append records from other dbf file:

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

import records from csv file to dbf 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, 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

/COLUMNS select columns

syntax: /COLUMNS:field1,field2

export dbf to csv format:

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

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

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 | /sql2000 | /postgresql] [/NOCREATESTATEMENT]

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

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

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

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