WhiteTown Software, the official website.
Site map Home News Download Order Contacts Service   RU

CDBF for Windows
CDBF for Windows (console)
CDBF for DOS
CDBF for Linux
CDBFlite
CDBFapi
DBF Script               New!
CDBFinfo
CDBFShell
CDBFview

WhiteTown Wizards
DBF to CSV
DBF to MDB (Access)
DBF to XLS (Excel)
DBF to HTML
DBF to SQL
DBF to XML
DBF to PDB (Palm DataBase)
DBF to DBF
MDB (Access) to DBF
XLS (Excel) to DBF
PDB (Palm DataBase) to DBF
DBF Converters' Shell

XLS (Excel) to DBF Converter

Video presentation 1 New!
Video presentation 2 New!
 

 
See also:
DBF to XLS Converter
Allows you to convert
XLS (MS Excel) files
to DBF format.
Download now! 

XLS (Excel) to DBF Converter allows you to convert your XLS (Microsoft Excel) files to DBF 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.

You can select tables for export and set necessary options. The program can read both old XLS file and Excel 2007 files and convert then to dBase III, dBase IV, FoxPro, VFP and dBase Level 7 formats.

There are two executable files: XLS2DBF.EXE and XLS2DBF2007.EXE
The first application XLS2DBF.EXE supports XLS files only. It does not support Excel 2007 format.
The second application XLS2DBF2007.EXE supports both XLS and XLSX, XLSB files, but it will work only if you have MS Excel 2007 on your computer.

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
ZIP File Description Version Size
xls2dbf.zip XLS (Excel) to DBF Converter 1.25 770Kb

Ordering
XLS (Excel) to DBF 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

XLS (Excel) to DBF Wizard

XLS (Excel) to DBF. Command line description

Common parameters

/OVERWRITE=1Overwrite existing file.
/OVERWRITE=0Do not overwrite existing file. (Append to existing file).
/ASISCodepage as is.
/ANSIConvert to ANSI codepage.
/OEMConvert to OEM codepage.
/OPEN=1Open the output file after conversion.
/OPEN=0Do not open the output file after conversion.
/BATCHBatch mode. The program does not ask any questions (if possible).
/SILENTBatch mode. The program does not display any windows.
/WAITDo not close the program at the end. (Wait on the finish page).
/LOGCreate 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

XLS specific parameters

Drive:\Path\FileName.xlsSource XLS file
Drive:\Path\Output directory
/DBASE3Convert to dBase III format.
/DBASE4Convert to dBase IV format.
/FOXPROConvert to FoxPro format.
/VFPConvert to Visual FoxPro format.
/LEVEL7Convert to dBase Level 7 format.
/BLOCKSIZE=?????Set blocksize for memo fields.
Example:
/BLOCKSIZE=128
/REMCRLF=1Remove CR+LF in Memo fields.
/REMCRLF=0Do not remove CR+LF in Memo fields.
/HEADER=1Indicates that the first row contains columnnames, not data.
/HEADER=0Indicates that the first row contains data.
/ALLCHAR=1Tells the program to always read "intermixed" data columns as text.
/ALLCHAR=0Tries to detect fields types.
/PASSWORD=value Password for source file.
/DEFNUM=value Number of decimal digits in Numeric,Float,Double fields
/MAXFIELDS=value Max quantity of converted fields.
/TABLES=sheet1;sheet2 This paramater allows you to specify a particular worksheet or several of them.

XLS to DBF Converter DLL

////////////////////// sample1.cpp ////////////////////////////
//parameters in the command line
//
//sample1.exe source.xls c:\target\ ...
//

#include <windows.h>
#include <stdio.h>

typedef int (APIENTRY *Converter)(HWND, UINT, CHAR**);

int main(int argc, char* argv[])
{
	int	retval;
	HMODULE	h;
	Converter f;

	h = LoadLibrary("xls2dbf_d.dll");
	if (!h) retval = 200;
	else
	{
	f = (Converter)GetProcAddress(h, "XLStoDBF_Converter");
	if (!f) retval = 300;
	else	retval = f(NULL, argc, argv);
	}
	FreeLibrary(h);

	printf("ret = %d\n", retval);
	return retval;
}
//
////////////////////// sample1.cpp ////////////////////////////

 

////////////////////// sample2.cpp ////////////////////////////
//parameters in the source code
//
//sample2.exe
//

#include <windows.h>
#include <stdio.h>

typedef int (APIENTRY *Converter)(HWND, UINT, CHAR**);

int main(int argc, char* argv[])
{
	int	retval;
	HMODULE	h;
	Converter f;

	int	n=0;
	char	*params[10];

	params[n++]=strdup(__argv[0]);
	params[n++]=strdup("nophones.xls");
	params[n++]=strdup("c:\\tmp\\");
	params[n++]=strdup("/ansi");
	params[n++]=strdup("/overwrite=1");

	h = LoadLibrary("xls2dbf_d.dll");
	if (!h) retval = 200;
	else
	{
	f = (Converter)GetProcAddress(h, "XLStoDBF_Converter");
	if (!f) retval = 300;
	else	retval = f(NULL, n, params);
	}
	FreeLibrary(h);

	printf("ret = %d\n", retval);
	return retval;
}
//
////////////////////// sample2.cpp ////////////////////////////

0.00387406349182 | Privacy policy | Copyright © 1996-2009, WhiteTown Software