|
|
 |
DBF to XLS (Excel) Converter
DBF to XLS (Excel) Converter allows you to convert your dbf files to XLS (Microsoft Excel) format.
MS Excel up until 2007 version used a proprietary binary file format called Binary Interchange File Format (BIFF) as its primary format. Excel 2007 uses Office Open XML as its primary file format.
XLS is a wide-used format, many programs allow saving information in XLS format.
It is very convenient and Microsoft Excel provides many possibilities for information management.
But MS Excel does not understand some types of dbf files, it does not understand memo fields, it does not understand long character fields.
DBF to XLS (Excel) decides these problems. It allows you to transfer your dbf files to XLS or XLSB (Excel 2007) formats quickly and easily.
The program supports dBase III, dBase IV, FoxPro, VFP and dBase Level 7 formats.
2007 Office System Driver. This download will install a set of components that can be used by non-Microsoft Office applications to read data from 2007 Microsoft Office system files.
The program supports command line interface. So, you can run it with necessary parameters in a batch mode from the command line or from Windows scheduler without human beings.
Besides, the Site license includes a DLL which you can use from your own application.
|
Downloads
Ordering
|
| DBF to XLS (Excel) 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 XLS (Excel). 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. |
XLS specific parameters
| Drive:\Path\FileName.dbf | Source DBF file |
| Drive:\Path\FileName.xls | Target XLS file |
| /OVERWRITETABLE=1 | Overwrite existing table. |
| /OVERWRITETABLE=0 | Do not overwrite existing table. (Append to existing table). |
| /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. |
| /TYPE=ANY | Output file type is Excel 95/2003 |
| /TYPE=2007 | Output file type is Excel 2007
If you do not have Excel 2007 installed, but would like to export to Excel 2007 format,
then you need to install this.
|
| /SINGLESHEET | Create only one sheet in the XLS file. |
DBF to XLS Converter DLL
////////////////////// sample1.cpp ////////////////////////////
//parameters in the command line
//
//sample1.exe source.dbf target.xls ...
//
#include <windows.h>
int __declspec(dllexport) __stdcall DBFtoXLS_Converter(HWND hwnd, int argc, char *argv[]);
int
main(int argc, char *argv[])
{
return DBFtoXLS_Converter(NULL, argc, argv);
}
//
////////////////////// sample1.cpp ////////////////////////////
|
|
////////////////////// sample2.cpp ////////////////////////////
//parameters in the source code
//
//sample2.exe
//
#include <windows.h>
int __declspec(dllexport) __stdcall DBFtoXLS_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.xls");
params[n++]=strdup("/ansi");
params[n++]=strdup("/overwrite=0");
return DBFtoXLS_Converter(NULL, n, params);
}
//
////////////////////// sample2.cpp ////////////////////////////
|
|