| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing a QueryTable data source
I've set up a QueryTable using "import external data". Works fine, except I
want to change my datasource. When you import, it pulls in your machine name, hard coded database name, etc. I don't want that stuff. I want this much "ODBC;DSN=MyDB;Trusted_Connection=Yes" Is there a way to change this from the UI? If not, a way to do it programmatically? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Source Data using V-lookup | Excel Worksheet Functions | |||
| Changing Data Source | Excel Worksheet Functions | |||
| Changing only source file of pre-existing text import QueryTable? | Excel Programming | |||
| Changing Data Source | Excel Programming | |||
| Changing Data Source Driver | Excel Programming | |||
Threaded Mode
