| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing Data Source
Hi,
I have taken over a task to modify a report, in Excel, using access data. However i can't change the database that the excel queries point to. I did it by QueryTable.Connection, but it doesnt change the SQL in MS Query. When i edit the query, i go to the next stage after where you normally select the database. Can anyone help? Thanks nathan |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing Data Source
Create a new query???
-- Hope this helps. Thanks in advance for your feedback. Gary Brown "nathan_savidge" wrote: Hi, I have taken over a task to modify a report, in Excel, using access data. However i can't change the database that the excel queries point to. I did it by QueryTable.Connection, but it doesnt change the SQL in MS Query. When i edit the query, i go to the next stage after where you normally select the database. Can anyone help? Thanks nathan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing data source in a pivot | Excel Discussion (Misc queries) | |||
| Changing query data source | Excel Discussion (Misc queries) | |||
| Changing a Data Source in Excel 2000 | Excel Discussion (Misc queries) | |||
| Changing Data Source for Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot and changing External data source | Excel Discussion (Misc queries) | |||
Linear Mode
