Using a saved query to retrieve data from different sources

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i would like to use a saved query in more than one worksheet to retrieve data
from more than one ODBC data source.

however when i copy the query between sheets it does not give me the option
to change the data source.

is this possible wihtout renaming the query seven times and and pointing it
at seven different sources?

Any help would be appreciated.

thanks
 
you could write a little VBA to do a REPLACE on the querytable's
connection string.

have you looked into parameter queries? (though it's success would
depend on what your actually retrieving from what..

what type of datasource (which driver) are we talking about?

a bit more detail would be nice :)



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Gary Hall wrote :
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO retrieval from close workbook-data type issue 2
VBA - retrieve data on last create named range from previous inserted named range 0
Advice on multiple macros, same code just a different column 9
Oh would you belive it Facebook and Open Source 4
Retrieve data saved in pivot table 2
Excel ODBC driver created table/inserted data lost on application 1
Using an Excel Spreadsheet as A Data source for Miscrosoft Query 1
Toggling save warning message on or off 9

Back
Top