Oracle Data Wizard product tour

Data Import Wizard is a powerful tool for importing data to Oracle tables from files of the following formats: MS Excel, MS Access, XML, DBF, TXT and CSV. The tool also allows you to define the key columns for the table and select whether to skip, update or delete records where the key value matches the imported one.

When running, the wizard guides you through the process of importing data to Oracle tables.

Bear in mind that using templates when working with Data Import Wizard can be of considerable importance. If you are eager to economize your time and efforts spent for performing customizing operations, using Data Import Wizard templates is exactly what you need!

For importing data from an Excel file to your Oracle database you need to select the files in the file list and set the correspondence between the source Excel columns and the target Oracle table fields.

Specify ranges in the grid for the target field selected in the Fields list. Using the popup menu of the Ranges list you can add or edit ranges manually, as well as remove them or change their order.

After you define a range for the selected field, proceed to the next one. If the source file and the destination table have the same order of columns or rows, you can use the Auto Fill Cols or Auto Fill Rows buttons to set the correspondence between them automatically.