MS Query - changing databases

  • Thread starter Thread starter emea training 2
  • Start date Start date
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
 
usually all you have to do is change the file path. what
method are you using. how is the query pointing now.
 
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
 
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.
 
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

Excel Lotto - How to find duplicate 6-number groups from result database? 2
Change source of linked database query 1
Access Access Report Works on One Machine but not Another 3
Can't create a report from my query in Access 1
Change database connection between live and test for external data 5
Excel 2003 randomly loosing database queries 1
Access Dcount (multiple criteria) 3
Change Server for Query 3

Back
Top