| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calls to extract data from an open database
I have a workbook that on the open event connects to an Oracle database
using ADO, this works fine. I need to code various calls to the data base to run several queries. How do I achieve this? Do I have to repeat the ADO connection string to the database complete with password etc; I am sure this is not necessary. Any code will be very gratefully received. -- with kind regards Spike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract data from another database | Excel Worksheet Functions | |||
| Extract data from database | Excel Worksheet Functions | |||
| HELP: VBA Code to extract data from an SQL Server database and put it into Access Database | Excel Programming | |||
| database calls | Excel Programming | |||
| database calls | Excel Programming | |||
Threaded Mode
