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.?

Report message to a moderator

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: 3212
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/

Report message to a moderator

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: 68775
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Or OO4O (Oracle Object for OLE)

Report message to a moderator

Previous Topic: Oracle services
Next Topic: Oracle 11g R2 on windows 7
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Mar 20 03:42:32 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.