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.

We want to import Excel data to a target table with name orders. So, change the target table name accordingly. Remove the mappings for those Excel sheets we do not need to import.

In the Field Mappings column, you can click '...' button and check the source-to-target field mappings for Sheet1$ -> orders table pair. Tou will be able to rename columns, change their types, remove extra columns, specify primary key etc.

Excel to SQLite Table and Column Mappings

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

Importing Result

Next topic: Importing Data from dBase (DBF) Files

See also

Dragging Files

Importing Data

Practical Cases