MS Query - changing databases

E

emea training 2

I want to replicate an ODBC report for a number of different countrie
on different databases.

Currently I have to create a new file and query for each differen
database.

Is it possible to change which database a query points to withou
re-writing it completely, as this would be much faster.

The databases appear to have identical attributes (tables, fields
etc.)

Many thanks
 
F

Frank Stone

usually all you have to do is change the file path. what
method are you using. how is the query pointing now.
 
E

emea training 2

The query is saved within an Excel workbook.

After going Data > Get External Data > Edit Query in Excel to get int
MS Query I then tried to go File > Table Definition in Query to chang
the data source. It let me do this but then prompts me to create a ne
table
 
F

Frank Stone

don't do the File>Table definition thing. instead click
the SQL icon. this will didplay the query it is running.
you need to change the file path in this SQL statement.
 
Top