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 in Windows Explorer to import data from:

Selecting Database Files

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:

Dragging and Dropping Database Files

Note: Instead of dragging files from Explorer, you can use File | Import Database Files... menu.

Choose Import Action

After dropping the files, Exportizer asks to choose the needed import action:

Data File Import Action

Here, you can also deselect mistakenly selected items.

For now, we choose the most complex (and powerful) action: importing tables from the dragged files with full control of the process.

Expected Result

After following the instructions, we are expecting to append new data to our existing two tables, and import six new tables:

Database Tables after Data Importing

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

See also

Opening Databases

Dragging Files

Importing Data

Practical Cases