link ODBC connection to an Oracle database
 

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
--
Richard

link ODBC connection to an Oracle database
 

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