|
|
 |
DBF to MDB (Access) Converter
DBF to MDB (Access) Converter allows you to convert your dbf files to MDB (Microsoft Access) format.
MDB is the file format used by Microsoft Access XP and earlier versions. It was replaced by the ACCDB format with the release of Microsoft Access 2007.
Sometimes Access is unable to open DBF files or even damages them.
Besides, MS Access does not understand long Character fields (more than 255 characters).
DBF to MDB Converter decides these problems.
The program reads DBF files in dBase III, dBase IV, FoxPro, VFP and dBase Level 7 formats.
Besides, you can optionally remove trailing spaces and select the output codepage.
There are two versions executable files and DLLs:
- DBF2MDB.EXE and DBF2MDB_D.DLL can create and open MDB files till the MS Access 2003 format.
- DBF2MDB2007.EXE and DBF2MDB_D2007.DLL can create and open both MDB and ACCDB files (MS Access 2007).
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 MDB (Access) 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 MDB (Access). 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. |
MDB specific parameters
| Drive:\Path\FileName.dbf | Source DBF file |
Drive:\Path\FileName.mdb Drive:\Path\FileName.accdb | Target MDB file or ACCDB 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. |
| /LANG=language | Language string. Something like: ;LANGID=0x0409;CP=1252;COUNTRY=0 |
| /VER=value | Version of MDB file. Available values: 0, 1, 2, 3, 4 (Access 2007) |
| /MAXLEN=value | Limits the maximum length of information in a field.
i.e. /MAXLEN=250 will take only first 250 characters. |
| /AUTOLIMIT=step | If SQL Expression is too long then the program will try to decrease MAXLEN value with specified step. |
DBF to MDB Converter DLL
////////////////////// sample1.cpp ////////////////////////////
//parameters in the command line
//
//sample1.exe source.dbf target.mdb ...
//
#include <windows.h>
int __declspec(dllexport) __stdcall DBFtoMDB_Converter(HWND hwnd, int argc, char *argv[]);
int
main(int argc, char *argv[])
{
return DBFtoMDB_Converter(NULL, argc, argv);
}
//
////////////////////// sample1.cpp ////////////////////////////
|
|
////////////////////// sample2.cpp ////////////////////////////
//parameters in the source code
//
//sample2.exe
//
#include <windows.h>
int __declspec(dllexport) __stdcall DBFtoMDB_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.mdb");
params[n++]=strdup("/ansi");
params[n++]=strdup("/overwrite=0");
return DBFtoMDB_Converter(NULL, n, params);
}
//
////////////////////// sample2.cpp ////////////////////////////
|
|