How to import data from Excel to Oracle Database

Today, the customer suddenly wants to modify a large amount of data, so he has to look at how to import the data in Excel to Oracle. Now the steps are briefly recorded as follows (refer to the relevant onlineArticle):

1. Prepare data: Create required data in Excel

2. Save the data in Excel as a text file (with tabs separated)

3. Import the data saved to a text file to PL * SQL.

In PL * SQL, select Tools --> text importer, select "data from textfile" in the displayed window, and then select "Open Data File ",

Select the text file containing data in the pop-up file selection box. The data from textfile displays the data to be imported.

4. Configure the following in Configuration:

Note: If you do not select "name in Header", the field name will be imported into the database as a record, resulting in data errors.

5. Click data to Oracle, select the table to be imported, and associate fields in the text with fields in the Table in fields.

6. Click Import to import data.

7. View imported data

OK. Now the data is imported successfully.