Excel-based oracle import methods

Excel-based oracle import methods

Excel-based oracle import methods
1. Same as the db2 import Method
2. Use sqlldr to load data:
1) Save the excel file as a. csv file and separate the text files with commas (,), such as table.csv.
2) Compile an insert. ctl file and use sqlldr for import!
The insert. ctl content is as follows:

Load data
Infile 'table.csv'
Append into table tablename
Fields terminated ','
(Field1, field2, field3,... fieldn)
3) execute the command: sqlldr user/password control = insert. ctl