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:
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:
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.
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:
Next topic: Importing Data from dBase (DBF) Files
- Exporting dBase (DBF) to SQL Script
- Exporting CSV to DBF
- Creating Schema for a Text Table
- Exporting Large Tables
- Exporting SQLite to Excel
- Exporting Excel to Firebird
- Exporting Paradox to Access
- Migrating Data from PostgreSQL to Oracle
- Exporting BLOBs to Individual Files
- Exporting to HTML Using Template
- Importing Database Files from Explorer