Forum Stats

  • 3,768,552 Users
  • 2,252,809 Discussions
  • 7,874,617 Comments

Discussions

How To Connect Microsoft Excel To Oracle DB

Hi,

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
[http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html]

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

I also tried using the bellow link
[http://blog.mclaughlinsoftware.com/microsoft-excel/how-to-query-oracle-from-excel-2007/]

and

[http://www.youtube.com/watch?v=Adz0zZFePf8]

Got stuck where oracle connectivity was needed.

Thanks,
Vishwamber Shetty

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