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 |
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 |
All times are GMT +1. The time now is 01:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com