link ODBC connection to an Oracle database

[Guest]

I'm trying to run an SQL query on an Oracle database.
I've looked at some previous posts, but still have problems.

1. Dim conData as ADODB.Connection
gives error "User-defined type not defined"
Do I need an add-on or similar?

2. Also, could you give me sample of how to insert SQL code into Excel macro
after establishing connection?

Thanks

 

[google]

Dear Richard,

You probably forgot to add a reference to the ADODB library.

To not have to learn all the ADO stuff you can also use the SQL*XL
addin in which it is all done for you. You can simply record a macro
connecting through SQL*XL and the appropriate references are set for
you... and the code to connect will be fully generated!

Please have a look at SQL*XL at www.oraxcel.com/projects/sqlxl

Any questions, just post it on www.oraxcel.com/forums or get in touch
through the enquiries form at the website