| 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 |
| 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) | |||
Threaded Mode
