Jiri in SF wrote:Your blog completely forgets the most generic option of Heterogeneous Services for connecting to the Excel workbook as if it's a database (e.g. database link) using an Excel ODBC driver.
I posted article about this on my blog few weeks ago, there are some easy ways to load excel to oracle
Here SID is the name of data source that you have just created.
EXCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.12.0.24)(PORT = 1521)) ) (CONNECT_DATA = (SID = EXCL) ) (HS = OK) )
under SID_LIST_LISTENER like:
(SID_DESC = (PROGRAM = hsodbc) (SID_NAME = <hs_sid>) (ORACLE_HOME = <oracle home>) )
Dont forget to reload the listener
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = d:\ORA9DB) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = ORA9DB) (ORACLE_HOME = d:\ORA9DB) (SID_NAME = ORA9DB) ) (SID_DESC = (PROGRAM = hsodbc) (SID_NAME = EXCL) (ORACLE_HOME = D:\ora9db) ) )
4- In %ORACLE_HOME%\hs\admin create init<HS_SID>.ora. For our sid EXCL we create file initexcl.ora.
C:\> lsnrctl reload
5- Now connect to Oracle database and create database link with following command:
HS_FDS_CONNECT_INFO = excl HS_FDS_TRACE_LEVEL = 0
Now you can perform query against this database like you would for any remote database.
SQL> CREATE DATABASE LINK excl 2 USING 'excl' 3 / Database link created.
Or refer to this Article...
SQL> SELECT table_name FROM all_tables@excl; TABLE_NAME ------------------------------ DEPT EMP