Oracle Database Query into Excel

[ChrisUK]

Hi.

I'm struggling getting information from an Oracle database, I'm falling down at the connection string stage and getting an "undocumented error"

Here is the string I'm using, can anyone suggest another string or way to do this please.

TIA

Chris

Set ConnectDB = New ADODB.Connection
ConnectString = "Provider=msdaora;Data Source=Server1;User Id=userid;Password=userpw;"

ConnectDB.Open ConnectString

 

[nbrcrunch]

I don't know if this would work, but have you tried recording the manual steps of performing the connection and then examining the code?

just a thought.

 

[ChrisUK]

I've got a bit further ....

It seems you need the Oracle client running on your PC which is a bit crap really, why you can't use ODBC or ADO like most other DB's is beyond me ... another reason why not to buy Oracle I suppose.

It unfortunatly means I can't fdo this on my own, I need to enlist others in the organisation and it starts to get very messy!

Thanks for your help anyway