Export DBF to CSV
To
export a dbf file to CSV format, open File | Save as/Export menu,
and select file type: CSV.
Export
to dialog box opens. Select the fields to be exported and specify
their order using up and down arrows.
You can select also field delimiter: comma, semicolon, tab, space or enter other delimiter.
Export DBF to CSV from the command line:
"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" file.dbf /EXPORT:file.csv
[/SEPx |/SEPTAB |/SEPSPACE | /SEPPIPE | /SINGLEQUOTA | /DOUBLEQUOTA | /REVERSE | /STARTFROM | /FILTER | /SORTBY:field | /UTF8]
examples:
Simple export dbf to csv
"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe"
sample.dbf /EXPORT:sample.csv
Export DBF to CSV with double quotes
"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe"
sample.dbf /EXPORT:sample.csv /DOUBLEQUOTA
Export dbf to csv with semicolon as delimiter
"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe"
sample.dbf /EXPORT:sample.csv /SEP;
Export DBF to CSV with Pipe as delimiter
"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe"
sample.dbf /EXPORT:sample.csv /SEPPIPE
Export DBF to CSV with columns selection
"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" sample.dbf /EXPORT:sample.csv /COLUMNS:ZIP,NAME
Exporting with filter
"c:\Program Files\DBF Viewer 2000\dbview.exe" sample.dbf /EXPORT:sample.csv /FILTER:filter.txt
Syntatx for filter file (each line):
Fieldname:Value|Expresion
Exporting from record N
"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" sample.dbf /EXPORT:sample.csv /STARTFROM:10
Exporting with sorting
"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" sample.dbf /EXPORT:sample.csv /SORTBY:NAME
Exporting with UTF-8 encoding
"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" sample.dbf /EXPORT:sample.csv /utf8
Exporting DBF with symbol @ as delimiter
"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" sample.dbf /EXPORT:sample.csv /sep:@
DOWNLOAD for FREE
Updated Tue, 14 Nov 2023
See
also: DBF to XLS (excel), DBF to XML, DBF to SQL,DBF to MySQL, CSV Converter,command line options,
Filtering records in dbf
file
Back to DBF Viewer 2000 Home
Page top | Contacts | Copyright © HiBase Group, 2002-2023
|