connecting to an oracle database without odbc by excel vba

**vicktorz** · 10-21-2014, 02:52 AM

Hi..

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

Thanks,
Vijay

**romperstomper** · 10-21-2014, 03:55 AM

Do you have the Oracle client tools installed? If not, you can't connect.

**vicktorz** · 10-21-2014, 04:12 AM

Hi romperstomper,

Thanks for reply..

i'm installing Oracle Client tools.. Pls tell me how to do using client tools..

Thanks,
Vijay

**romperstomper** · 10-21-2014, 04:34 AM

Here's a simple ADO example:

Please Login or Register  to view this content.

Depending on the nature of your setup, you may need to use different connection details - you can find many variations here: http://www.connectionstrings.com/ora...e-db-oraoledb/

Re: connecting to an oracle database without odbc by excel vba