Home
DBF Viewer 2000 - Online Help Prev Page Prev Page
Introduction
Hotkeys
Command line options
Working with databases
Opening DBF files
Creating New DBF file
Modifying file structure
Viewing satistics
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
Commands
File
Edit
View
Tools
Options
Information
Support
How to purchase
Command line options
 		[Previous] [Main] [Next]

Open single dbf file

 dbview.exe file.dbf

Start without Open dialog

 dbview.exe /NOOPEN

Run in read only mode:

dbview.exe file.dbf /RO
dbview.exe /RO

Run in shared mode

dbview.exe file.dbf /SHARED
dbview.exe /SHARED

Use OEM characters

dbview.exe file.dbf /OEM
dbview.exe /OEM

Use ANSI characters

dbview.exe file.dbf /ANSI
dbview.exe /ANSI

Append/Import records from DBF or TXT files

examples:

append from dbf:
dbview.exe /APPEND:file1.dbf,file2.dbf

append from text file:
dbview.exe /APPEND:file1.dbf,file2.txt /SEP;
or dbview.exe /APPEND:file1.dbf,file2.txt /SEP; /ZAP

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

Open with filter

dbview.exe myfile.dbf /FILTER:myfilterfile

filter file format:

Field name:Value|Expression

Export records

dbview.exe file1.dbf outfile.ext [options]
The command export records from file1.dbf to file1.ext, where ext - (txt, csv, sql, xml, xls, html, rtf)

options:
/SEP set delimiter (txt/csv format only)
/SKIPD skip deleted records
/SKIPM skip memo fields

export to txt format:
dbview.exe file1.dbf /EXPORT:file2.txt /SEP:
where : delimiter
or
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

export to dbf III
 dbview.exe file1.dbf /EXPORT:file2.dbf /DBASE3

export to visual foxpro
 dbview.exe file1.dbf /EXPORT:file2.dbf /VFP

export to sql format:
 dbview.exe file1.dbf /EXPORT:file2.sql

export to xls format:
 dbview.exe file1.dbf /EXPORT:file2.xls

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

dbview.exe /GOLASTRECORD

Fix dbf file with incorrect size

dbview.exe file.dbf /FIX

or with wildcards
dbview.exe *.dbf /FIX


Pack Dbf file

dbview.exe file.dbf /PACK
or with wildcards
dbview.exe *.dbf /PACK