dBase
The dBase export and import are not available in Unicode installations.
When using the 'dBase' format, you import data from a dBase III table.
You enter a configuration name and select among the 'dBase III', 'dBase IV', or 'dBase V' formats during configuration.
Then, you specify the location of the import data.
enaio® server checks whether the path of the import files corresponds exactly to that specified for enaio® server. If this is the case, these files are imported. If this is not the case, the files will be transferred from the processing computer to enaio® server.
Specify the directory containing the file. If more than one table is present, select the required table using the Table name field. If more than one file with identical table structures is present, select 'All tables'.
The following additional specifications can also be made.
-
Rename import files before import
The import file is renamed before importing. It receives the file extension 'bak'. This excludes it from the next import.
-
Delete import files after import
Import data files can be deleted automatically after a successful import. This is recommended in combination with log settings with which you can log successfully imported records separately from corrupt records.
The OEM or ANSI encoding of the dBase files must match the encoding of the OLE DB provider; otherwise, special characters will be displayed incorrectly.
This setting is managed using the following key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Xbase