How to read the data from the xl sheet and load into a table? to
How to read the data from the xl sheet and load into a table?
The XL sheet contains four columns and 55 thousand rows, and I need to read that data from XL sheet and load the same into a table.
Thanks in advance.
Two solutions I have used:
For one-off cases:
1) create INSERT instructions in an additional column of the worksheet, copy & paste them into a text file, execute them with a "@textfile.txt" in SQL*Plus.
Might not be efficient enough for 55K rows!
For frequent use:
2) save the file in .csv format, load this with SQL*Loader.
Another solution - I've tried bits of this, but never all together:
3) load the Excel into Access and update the db with ODBC. This might lend itself to a "batch" solution with an Access macro.
The Last option - sending the xl sheet into access database and export that into oracle ODBC is easy to upload the xl data into oracle database
Click Here to Expand Forum to Full Width