In Exportizer Enterprise, there is a possibility to import data from different database files (or folders with database files) dragged from Windows Explorer. Here, we show how to do that quickly and correctly, and give you all needed explanations and some useful tips.
So, let's begin.
Select Database Files
First, open/connect a database to import data to. In our example, it is an SQLite database with two tables: customer and payment.
Then, let's select the database files to import data from:
As you see, we chose a folder with DBF files, a Firebird database (.fdb file), and an Excel worksheet. In our example, selected folder contains two files customer.dbf and payment.dbf, Firebird file contains 5 tables with client communications, and the Excel file contains a data sheet with some client orders.
Note: When you select folder(s), no sub-folders are processed. Selected folder(s) must contain database files of type dBase (DBF), Paradox (DB), or text/CSV; other files are ignored.
Drag Selected Files to Exportizer
Drag selected files and folders and drop them into the Exportizer Enterprise window with a target database connected:
Choose Import Action
After dropping the files, Exportizer asks to choose the needed import action:
Here, you can also deselect mistakenly selected items.
For now, we recommend you to choose the most complex (and powerful) action: importing tables from the dragged files with full control of the process.
After following the instructions, we are expecting to append new data to our existing two tables, and import six new tables:
Detailed Import Instructions
So, if you are interested, let's dive into more details. We'll discuss processing files of each data type in separate topics.
Next topic: Importing Data from Excel File