Import Excel files through PL/SQL

PL/SQL is similar to SQL Sever in importing Excel data. It is used to find a function to import Excel Data. follow the steps below. The following is a detailed process, hoping to help cainiao like me.

1. Prepare an Excel table.

Right-click the data table and choose edit data.

Select data, right-click, and select copy to excel

2. Adjust the Excel table

You can delete column A and column F, and then stick your data to the bcde column. The advantage of this is that when importing an Excel file, no errors are caused by format or other text issues.

3. Prepare for Import

Select tool-ODBC importer. There are three items in user/systemdsn. here we need to select the second item Excel files

Select connect. In the pop-up box, select the Excel file you want to import.

Preview your data, and then click data to Oracle

Add the owner and the data table you want to add. Here is t_admin. Click Import.

4. View data:

The imported data already exists.