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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing a QueryTable data source
Mike
You can change the Connection and CommandText properties of the QueryTable object. I've never really done it from the import side, just the standard query table so it may be slightly different. I'll be it's real similar to this http://www.dicks-clicks.com/excel/Ex....htm#ChangeSQL Dick Mike Jones wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing a QueryTable data source
What I'm seeing is that I can change it programmatically like this, but when
I save my XL spreadsheet, then reopen, its back to how it originally was; with all the extra, unwanted stuff. Strange. "Dick Kusleika" wrote in message ... Mike You can change the Connection and CommandText properties of the QueryTable object. I've never really done it from the import side, just the standard query table so it may be slightly different. I'll be it's real similar to this http://www.dicks-clicks.com/excel/Ex....htm#ChangeSQL Dick Mike Jones wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing a QueryTable data source
Mike
Oh, I see. I don't think you can prevent Excel from doing what it wants to your strings. If you describe your situation and why you want to do this, maybe someone will have another way to accomplish it. -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com Mike Jones wrote: What I'm seeing is that I can change it programmatically like this, but when I save my XL spreadsheet, then reopen, its back to how it originally was; with all the extra, unwanted stuff. Strange. "Dick Kusleika" wrote in message ... Mike You can change the Connection and CommandText properties of the QueryTable object. I've never really done it from the import side, just the standard query table so it may be slightly different. I'll be it's real similar to this http://www.dicks-clicks.com/excel/Ex....htm#ChangeSQL Dick Mike Jones wrote: 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 |
Reply |
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 |