Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query source location - how do I change?
I have set up an Excel worksheet so that it pulls data
from an Access database when the user fills out two cells. When I distribute this worksheet, the location for the Access database will have changed. Is there a way for me to somehow programatically update the location for the Query source (database) without having to manually go recreate the query to point to the new source? Thanks! Jennifer Crawford |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query source location - how do I change?
Jennifer,
will \\Server\path\subpath\filename.mdb format work for you? steve "Jennifer Crawford" wrote in message ... I have set up an Excel worksheet so that it pulls data from an Access database when the user fills out two cells. When I distribute this worksheet, the location for the Access database will have changed. Is there a way for me to somehow programatically update the location for the Query source (database) without having to manually go recreate the query to point to the new source? Thanks! Jennifer Crawford |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change source of linked database query | Excel Discussion (Misc queries) | |||
Change data source for MS Query | Excel Discussion (Misc queries) | |||
Can you change or alter source data using microsoft query? | Excel Discussion (Misc queries) | |||
How do I change the datasource location for a query in Excel 2003 | Excel Discussion (Misc queries) | |||
MS Query Data Source Change | Excel Discussion (Misc queries) |