Forum Stats

  • 3,768,552 Users
  • 2,252,809 Discussions


How To Connect Microsoft Excel To Oracle DB


My team recently took over a process from another company. The other company had a macro written which connects to oracle DB and gets the o/p result in Excel.
If i try to use this macro based sheet, I get error.

Though i pass the right password it through's error.

Error is "ORA-06413: Connection not open"
Where as if i try the same user name and password in toad it works.

I see that in my system i don't have "ORACLE Provider for OLE DB" and i also don't have "Oracle DB Driver".

I downloaded 64-bit Oracle Data Access Components (ODAC) Downloads from the bellow link

But it had install file as install.bat and configure.bat and on clicking nothing much happened.

I also tried using the bellow link



Got stuck where oracle connectivity was needed.

Vishwamber Shetty

Edited by: Vishwamber Shetty on Apr 24, 2013 6:09 PM
This discussion has been closed.