| Home |
| Search |
| Today's Posts |
|
#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 |
| 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
