Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How To Connect Microsoft Excel To Oracle DB

Vishwamber Shetty-OracleApr 24 2013 — edited Apr 24 2013
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 22 2013
Added on Apr 24 2013
0 comments
8,206 views