Excel Queries Against Multiple Databases

[Robert Minneman]

I'm currently trying to create stored queries that compare
data across tables in different databases on different
servers.

Is this possible with MSQuery. After a 'fairly'
exhaustive search of MS Query help, Excel help, and the
Microsoft online KB, I'm not finding anything that
is "obvious" on how to make this work.

Your assistance is appreciated.

Robert Minneman
(e-mail address removed)

 

[merjet]

How many databases, how big, how often? If quite
limited you could import them to Excel workseets &
write VBA code to do a cell-by-cell comparison.

HTH,
Merjet

 

[Robert Minneman]

2 databases, and the data sets can be fairly large.

We don't neccessarily need a comparison between the two
databases, but we want to produce a single query that
pulls data from both databases into an Excel spreadsheet
for reporting purposes.

Robert Minneman