Import Excel Data
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.
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.