Previous topic: Importing Data from Excel File
In the previously discussed data importing example, among other items, we dragged and dropped a folder with DBF files. Let's see, what is done with these files in Exportizer.
Registering a Folder as a Database
Before importing data, Exportizer asks either to register the dragged folder as a database in Exportizer:
If you want to use this folder in Exportizer on the regular basis, it is better to register it. In our example, we choose No.
Choosing Database Driver
When processing the folder, the application needs to know what kind of data from the folder we want to work with:
We are interested in dBase files from that folder, therefore we choose Microsoft dBase Driver.
Choosing Import Settings
Next, Import dialog appears:
Here, the Export mode is important for us. We already have two tables in the target database, and want to append new records to them (the new records are coming from the dragged files). So, change the export mode to Append. Note: If the dragged files may contain data already present in the target tables, choose Append+Update.
Review other options and change the needed ones. Click Next.
Now, please check the source-to-target table mappings:
In the Field Mappings column, you can also check the source-to-target field mappings for each table pair.
Click Import. If there are no error, you'll see the following notification:
Next topic: Importing Data from Firebird database