-
How to read the data from the xl sheet and load into a table? to
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
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|