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:@

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

Page top | Contacts | Copyright © HiBase Group, 2002-2023