Excel Import via PL/SQL to the Database text Importer ODBC importer

Excel Imports to the database via PL/SQL First Method: Text Importer

1. prepare Excel to import data Jc.xls

2. change jc.xls file to jc.csv file

3. build a JC table in the database (FLH, MLH, ND, DAL, LJ Fields)

4. Open PL/SQL, such as operations

Select Open in the pop-up box, select the Excel file you want to import.

Preview your data , To see if the import was successful

The second method: ODBC Importer

1. prepare Excel to import data Jc.xls

2. build a JC table in the database (FLH, MLH, ND, DAL, LJ Fields)

3. Open PL/SQL, such as operations

There are three items in the user /System DSN, here we need to select the second Excel Files, Enter the database user name to import, password

Add the owner, and the data table you want to add the data to , field corresponding

View data: The imported data already exists.

Excel Import via PL/SQL to the Database text Importer ODBC importer