how to connect Oracle 11g release 2 in Excel VBA with ODBC

I have three questions.
any helps,thank you very much!
1.How to connect Oracle 11g release 2 in Excel VBA with ODBC?
2.How to insert records into a oracle table, for example, table HR.DEPARTMETS
3.How to read records from table HR.DEPARTMETS into a Excel sheet?

the following is the information about my Oracle instance:
Oracle_SID = ORCL
UID=system
PWD=system
SERVER=192.168.100.18

I want to read records from Oracle table HR.DEPARTMETS, and insert data from Excel into Oracle table HR.DEPARTMETS
Thanks very much,If you could give a full sample.

0 answers