How SQL Developer Import Excel

After exporting table data to Excel files in SQL Developer, we can do some import test. In this post, I'll show you how to import data from an Excel file.

To import excel to the database, we have 2 options:

1. Import Excel to be a New Table
2. Import Excel to an Existing Table

Import Excel to be a New Table

Table Import Menu

We right-click on "Tables" category, and select Import Data.

SQL Developer - Table Import Data Menu

Select Excel File

Click on Browse to select the right Excel file to import.

SQL Developer - Select Excel File

Select Excel Format

We choose "excel 2003+ (xlxs)" as our import format.

SQL Developer - Choose Excel Format

We preview the data and then click "Next" to proceed.

SQL Developer - Preview Import Data

Choose Columns

We can import the entire or a part of the data by choosing columns. The column order can also be changed here.

SQL Developer - Choose Columns

Adjust Column Definition

We can adjust columns' definition here.

SQL Developer - Adjust Column Definition

The datetime format of being import data should be especially taken care of.

SQL Developer - Adjust Datetime Format

Preview Import Task Summary

We confirm the import task by previewing its summary.

SQL Developer - Preview Import Task Summary

Perform Import Task

If everything is ready, please click "Finish". The feedback is as below.

SQL Developer - Import Task Finished

Import Excel to an Existing Table

Table Import Menu

We right-click on the table name, and select Import Data.

SQL Developer - Table Import Data Menu

Select Excel File

Click on Browse to select the right Excel file to import.

SQL Developer - Table Import Data - 1

Preview Excel File

We can preview the content data in the file. If you don't have the header row, please uncheck Header choice.

SQL Developer - Table Import Data - 2

Select Columns

Columns can be selectively imported. Here we select all columns.

SQL Developer - Table Import Data - 3

Map Columns

We can map columns by Name or Position as shown in the following image.

SQL Developer - Table Import Data - 4

Import Data Summary

In the summary, we can go back anytime by clicking the item which needs to be modified. If there's nothing wrong, we can import the data now.

SQL Developer - Table Import Data - 5

Import Data Confirmed

It shows "Task successful and import committed".

SQL Developer - Table Import Data - Finished

Refresh Table Data

To see new content, we click on Refresh icon.

SQL Developer - Table Refresh Data

We did it.