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