Michiel,

I just add a new connection to the file. I usually have a new sheet and then
move it to the area I want. You can use the refresh all icon and all of the
queries are updated.

In some cases, I use the table function and use a vlookup to join the two
files together. (I have to perform some calculations in order to join the
files or else I would have used the joins in MS Query.

--
Dan
Office 2007


"Michiel via OfficeKB.com" wrote:

Hello,

I import some data from a database using a query from MS Query.
The Query was created on a DSN named DSNDB1
Now I need to get the same data from DSNDB2 into the same report.

Is there a way to change the DSN used (DSNDB1) to the other one (DSNDB2) just
by setting that somewhere in MS Query. I do not want to use code here.
And I do not want to re-create the same query either. Just replace DSNDB1 by
DSNDB2 somewhere in a hopefully available option of MS Query.

Anyone who has a tip for me?

--
Message posted via http://www.officekb.com