Home » Infrastructure » Windows » connecting to an oracle database without odbc by excel vba (MS excel 2010)
connecting to an oracle database without odbc by excel vba [message #626124] Tue, 21 October 2014 01:58 Go to next message
vicktorz
Messages: 26
Registered: March 2013
Junior Member
Hi..

Can anyone pls tell me how to connect oracle database from Excel VBA without ODBC driver.?

Re: connecting to an oracle database without odbc by excel vba [message #626127 is a reply to message #626124] Tue, 21 October 2014 02:10 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
You could use OLEDB instead of ODBC.

http://blog.mclaughlinsoftware.com/microsoft-excel/how-to-query-oracle-from-excel-2007/
Re: connecting to an oracle database without odbc by excel vba [message #626307 is a reply to message #626124] Fri, 24 October 2014 09:50 Go to previous message
Michel Cadot
Messages: 68315
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Or OO4O (Oracle Object for OLE)
Previous Topic: Oracle services
Next Topic: Oracle 11g R2 on windows 7
Goto Forum:
  


Current Time: Sat Dec 03 23:01:32 CST 2022