How to read the data from the xl sheet and load into a table? to

[srinivasm]

Hi All,

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.

Regards,
Srinivas Medukonduru

[DaPi]

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.

[Sekhar]

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