Changing query data source

[Guest]

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

 

[Guest]

Hi Tony,

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