How Toad Import Excel File

Toad Import Excel

After exporting table data to Excel files in Toad, we can do some import test. In this post, I'll show you how to import data from an Excel file. It's a little more complicated.

Select Import Function

We can right-click on the table and select Import in the menu.

Toad for Oracle - Table Menu - Import

Select Target Table

We make sure the target table is correct, or we can choose another one to be imported in this page.

Toad for Oracle - Import Dataset - 1

Select Source File

We select Excel file and specify the location of the source.

Toad for Oracle - Import Dataset - 2

Specify Source Data

As you may have noticed, the first row is from line 2 because the column header takes the first line in the Excel file.

Toad for Oracle - Import Dataset - 3

Map Columns

We can either map column name or their position between table and the Excel file.

Toad for Oracle - Import Dataset - 4

Preview File

After mapping columns, we can preview the file content.

Toad for Oracle - Import Dataset - 5

Specify Primary Key

We don't specify anything here.

Toad for Oracle - Import Dataset - 6

Preview Result

As we can see, the column header is excluded from data range.

Toad for Oracle - Import Dataset - 7

Specify Import Mode

We select to commit all rows after import.

Toad for Oracle - Import Dataset - 8

Import Completed

The progress bar show the percentage of completion.

Toad for Oracle - Import Dataset - 9

Check Import Result

We should initiate another new session to check the result.

Toad for Oracle - Check Import Result

As we can see, the import is completed and committed.