Import Excel Data to Oracle using plsql

Use plsql to import Excel Data to Oracle 1 prepare Excel to import data

2. Save the Excel file as a text file (tab-separated) (*. txt ))

You can also save an Excel file as a Unicode file, to convert the file encoding format of the generated Txt Text to UTF-8 3 Import the new student.txt file to plsql open plsql connect to the oracle database to be imported and then open Tools --> Text importer... --> Open data file: select the txt file www.2cto.com to be imported.

4. The newly generated table fields in the structure of the imported data table correspond to the title of the first row of the Excel file. However, the Type of the newly generated table field needs to be set to nvarchar (the imported data is temporary data, (5) set the imported table and corresponding column in the Data to Oracle Tab.

6. Click the Import button at the bottom of the interface to complete the Import operation.