This content has been marked as final. Show 8 replies
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;