| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamically connecting to a remote database
In Excel, is there a way of creating a user interface which allows you to
connect to a DSN and return data to Excel based on user input? In this scenario, there would be many DSN's available but the interface would take user input (e.g. customer2), connect to the relevant DSN (customer2), run an SQL Query and return data to Excel. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Connect to Access Database On Remote Server | Excel Discussion (Misc queries) | |||
| Remote Filtering | Excel Discussion (Misc queries) | |||
| to AND or OR remote reference? | Excel Discussion (Misc queries) | |||
| remote links | Excel Worksheet Functions | |||
| remote links | Excel Discussion (Misc queries) | |||
Linear Mode
