VBA to connect to an Oracle database

[Blunder1]

Hi There,
I am trying to connect to an oracle database with no success...

If I use an SQL tool (Rapid) I have to add the server name. port number and Service name. I have Oracle installed on my PC (Oracle Client 11g and Oracle Client ORA Files). I have goggled about and cannot find a piece of code that works. Can anyone point me in the right direction please?

Thanks

Blunder

 

[PostTIT]

Connect to an Oracle database (Power Query) - Excel

Seems fairly self explanatory from this. Unless you're wanting to do something more/different than what you've said above?


This one has many more links to things that are relevant.

https://community.oracle.com/thread/1083666