Previous topic: Importing Database Files from Explorer

In the previous topic, we've learned how to import data into an opened database by dragging and dropping data files and folders from Windows Explorer. In the discussed example, among other items, we dragged and dropped an Excel file with client orders. Let's see, how to process it in Exportizer.

Registering an Excel File as a Database

Before importing data, Exportizer asks either to register the dragged Excel file as a database in Exportizer:

Asking to Register an Excel Database

If you want to use this Excel file in Exportizer on the regular basis, it is better to register it. In our example, we choose No.

Choosing Import Settings

Import dialog appears:

Import Excel to SQLite Options

Review the import options and change the needed ones. Click Next.

Table and Field Mappings

Now, please check the source-to-target table mappings:

Table and Field Mappings

We want to import Excel data to a target table with name orders. So, change the target table name accordingly.

In the Field Mappings column, you can also check the source-to-target field mappings for this table pair.

Click Import. If there are no error, you'll see the following notification:

Importing Result

Next topic: Importing Data from dBase (DBF) Files

See also

Dragging Files

Importing Data

Practical Cases