Plsql Importing Excel data methods

1. Save Excel file as (text file (Tab delimited) (*.txt))

2. Import the newly generated student.txt file into the Plsql
Open Plsql Connect to the Oracle database you want to import and then open Tools---Text importer ...--Open data file to select the TXT file to import

3. Set the Import data table structure
The newly generated table field will correspond to the first row header of the Excel file, but the newly generated table field type needs to be set, can be set to nvarchar (import data as temporary data and can be processed later for type conversion if necessary)

4. Set the imported table and corresponding fields in data to Oracle tab

5. Click the Import button below the interface to finish importing Excel data into Oracle via Plsql

Plsql Importing Excel data methods