Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change database connection between live and test for external data | Excel Discussion (Misc queries) | |||
Serial Letter- Connection with Excel database | Excel Discussion (Misc queries) | |||
Excel: How do I set up a cell to click it to link a database? | Excel Discussion (Misc queries) | |||
I can I select cells in a template and link it to a database? | Excel Discussion (Misc queries) | |||
ODBC Link to db with custom modules | Excel Discussion (Misc queries) |