Importing Excel data into Oracle

• Open the PL/SQL, interface, and click T00ls ODBC Imtorper in the menu bar to open the ODBC Importer options box

4. In the Data fromodbc page, select the format of the file you want to import, and select EXCELFiles. Enter the user name password. Then click Connect

6. In the pop-up Select Workbook dialog box, select the Excel file you want to import, and click OK. Click the table name in the import table in the Table/query that appears, and you can see the contents of the table you want to import in the resultpreview below

8. Click the Date to Oracle button to open the Date to Oracle Options box, select the name of the table you want to import, this import table is Sfism4.u_rf_id_data, choose SFISM4 in the Owner drop-down menu, and in the Table drop-down menu u_rf_id_ Data, in the fields select the field you want to import, this import field is Serial_number, click Import to import batches of data into the Oracle database, so that the import is completed.

Importing Excel data into Oracle