This content has been marked as final. Show 8 replies
Save the file as .csv file, then load the file into oracle using sqlLoader.
Multiple sheets does not matter how the records are listed matters and how that should go into the db matters.
Or the other approach that i generally use is to use HSODBC. You set up the heterogeneous connectivity to the excel file and load it into oracle. But if you are looking at faster and recommended options, SQL Loader or External tables are the options that you have.
HSODBC and SQL Loader are great tools within Oracle. I would like to share this alternate method that I found very handy in some cases using MS Access and ODBC.
-From MS Access link to the excel file
-Link to the Oracle table using ODBC. Make sure you select few columns to make the link update capable.
-Build update query and kick it off
I know this is not the Oracle way, but works great just with few clicks.
Each worksheet and each named range appears as a table, but since MS is case sensitive, you need to enclose the worksheet and named ranges in double quotes.
See http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4406709207206#18830681837358 for a brief explanation.
SELECT table_name FROM all_tables@custard; TABLE_NAME ------------------------------ Sheet1$ Sheet2$ Sheet3$ CDS TRACKS describe "Sheet1$"@custard SELECT * FROM "Sheet1$"@custard;
Thanks for your help!
You can use toad's import wizard to achieve this.
Through Menu option:- Database->Import->Import table data
This wizard supports various types of source data files like ( .txt , .mdb, .xls ) etc.
- Pradnya Shinde
use SQL Developer or DG4ODBC
Toad Import database, nice utility, better then sql Developer.