Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing query data source
I have just found out that the data a query is looking up is a backup file as
the query is not showing recent data. I want to point the query to the live data file (a dBase database). I cannot figure out where it is currently pointing to as I have changed the filenames of any dBase files I thought it could be pointing to then running the query & it still runs without throwing up any errors. How do I find out where the data source is located from the query? I figured that when I find the data file I will change the filename & run the query & it will come up with an error & allow me to point to the correct data source. TIA -- Tony |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing query data source
Hi Tony,
"TonyL" wrote: How do I find out where the data source is located from the query? I figured that when I find the data file I will change the filename & run the query & it will come up with an error & allow me to point to the correct data Try running this bit of macro to give you the connection string in Sheet1!A1: Sub FindConnection() Sheets("Sheet1").Range("A1").Value = Sheets("Your query sheet").QueryTables("Your query").Connection End Sub /Sune |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing ODBC data source for a query embedded in Excel | Excel Discussion (Misc queries) | |||
Changing data source on ODBC query | Excel Discussion (Misc queries) | |||
Data Source for MS Query | Excel Discussion (Misc queries) | |||
changing query source | Excel Worksheet Functions | |||
MS Query Data Source Change | Excel Discussion (Misc queries) |