Return
-
Title
How to Import *.xls (Excel) files using SQL*Loader. -
Description
Procedure on how to Import *.xls (Excel) files using SQL*Loader.
-
Resolution
1. Open the *.xls (Excel) file and select File | Save As.
2. Change the "Save as type:" to "CSV (Comma Delimited)(*.csv)", then click on Save, and close it.
3. Start Toad, and select DBA | Data Import\Export | SQL *Loader Interface.
4. Under Source Files, click ADD and add the Excel file (.csv) you want to import in the "Input File Name" field.
5. Under Destination Tables Tab, click ADD, and add the destination table.
6. Type a comma (,) in the "All Fields Delimited By:" field.
7. Select "INSERT" in the "Load Method".
8. Under the Parameters Tab, specify or create a new a Control File Name.
9. Click Execute Now.
10. Click Finished.