|
|
 |
DBF to CSV Converter
DBF to CSV Converter allows you to convert your dbf files to csv
(comma-separated value) format.
Generally, you can use any delimiter, such as TAB, semicolon etc.
The program supports dBase III, dBase IV, FoxPro, VFP and dBase Level 7 formats.
Since many programs understand CSV format then this programs can help you
transfer your data to another system.
The program supports command line interface.
Besides, the Site license includes a DLL which you can use from your own application.
|
Downloads
Ordering
|
| DBF to CSV Converter |
Price |
Personal license
Allows you to use the program by one person only (at work or at home or both). |
$29.95 |
Business license
Allows you to use the program by a small company on 2-10 computers. |
$99 |
Site license
Allows you to use the program in business environment and besides it includes a DLL which you can use from your own application. |
$199 |
|
ScreenShot

DBF to CSV. Command line description
Common parameters
| /OVERWRITE=1 | Overwrite existing file. |
| /OVERWRITE=0 | Do not overwrite existing file. (Append to existing file). |
| /SKIPDEL=1 | Skip records marked as deleted. |
| /SKIPDEL=0 | Do not skip records marked as deleted. |
| /ASIS | Codepage as is. |
| /ANSI | Convert to ANSI codepage. |
| /OEM | Convert to OEM codepage. |
| /OPEN=1 | Open the output file after conversion. |
| /OPEN=0 | Do not open the output file after conversion. |
| /BATCH | Batch mode. The program does not ask any questions (if possible). |
| /SILENT | Batch mode. The program does not display any windows. |
| /WAIT | Do not close the program at the end. (Wait on the finish page). |
| /LOG | Create a log file in a common repository for application-specific data. A typical path is C:\Documents and Settings\username\Application Data. |
/STATUS /STATUS=filename.ext | Create a text file with a current status (Conversion In Progress, Successful, Failed, Cancelled etc). By default: %Program dir%\status.log |
| /FILTER=condition | It allows you to convert records which satisfy the condition. |
CSV specific parameters
| Drive:\Path\FileName.dbf | Source DBF file |
| Drive:\Path\FileName.csv | Target CSV file |
| /REMTRAIL=1 | Remove trailing spaces in Character and Memo fields. |
| /REMTRAIL=0 | Do not remove trailing spaces in Character and Memo fields. |
| /REMCRLF=1 | Remove CR+LF in Memo fields. |
| /REMCRLF=0 | Do not remove CR+LF in Memo fields. |
| /ESCAPE=????? | Escape character before a single or a double quote.
Examples:
/ESCAPE=#
"/ESCAPE="" |
| /QUOTES=1 | Conclude character and memo fields in double quotes. |
| /QUOTES=0 | Do not conclude character and memo fields in double quotes. |
| /FIELDS=? | Delimiter between fields.
Example:
/FIELDS=;
Special values:
TAB means Tab (0x09) character.
NONE means absence of any delimiter. |
| /RECORDS=? | Delimiter between records.
Example:
/FIELDS=CRLF
Special values:
CRLF means 0x0d 0x0a.
CR means 0x0d.
LF means 0x0a.
NONE means absence of any delimiter. |
| /HEADER=1 | Include fields names. |
| /HEADER=0 | Do not include field names. |
/YYYYMMDD
/YYYY.MM.DD
/MM.DD.YYYY
/MM-DD-YYYY
/DD.MM.YYYY
/DD-MM-YYYY
/YYYY-MM-DD
| Use this format for date fields. |
| /STRIPYEAR=1 | Remove two leading digits in year for Date fields. i.e. 2006 -> 06 |
| /STRIPYEAR=0 | Display Date fields in default format |
DBF to CSV Converter DLL
////////////////////// sample1.cpp ////////////////////////////
//parameters in the command line
//
//sample1.exe source.dbf target.csv ...
//
#include
int __declspec(dllexport) __stdcall DBFtoCSV_Converter(HWND hwnd, int argc, char *argv[]);
int
main(int argc, char *argv[])
{
return DBFtoCSV_Converter(NULL, argc, argv);
}
//
////////////////////// sample1.cpp ////////////////////////////
|
|
////////////////////// sample2.cpp ////////////////////////////
//parameters in the source code
//
//sample2.exe
//
#include
int __declspec(dllexport) __stdcall DBFtoCSV_Converter(HWND hwnd, int argc, char *argv[]);
int
main()
{
int n=0;
char *params[10];
params[n++]=strdup(__argv[0]);
params[n++]=strdup("source.dbf");
params[n++]=strdup("target.csv");
params[n++]=strdup("/ansi");
params[n++]=strdup("/overwrite=0");
return DBFtoCSV_Converter(NULL, n, params);
}
//
////////////////////// sample2.cpp ////////////////////////////
|
|