| || |
Export Data From Excel to Oracle Data base
I have a stituation,
I have an excelsheet and I want to export this data in to Oracle Data Base(in one table)
Some body know the way or the correct code?
Your quickest way to a solution is probably to google (or use your favourite search engine) for it.
If you are familiar with Excel VBA you could write a macro to load the data via an ODBC call.
You don't need any code. Just use the Import Data option in SQL Developer.
But I am working with BPT technology and I need to use a vbscript code because I am automating this task
So do a command line call to sql loader.
SQL*Loader FAQ - Oracle FAQ
No need to reinvent the wheel.
I will try with this information, thanks a lot