Excel Queries Against Multiple Databases
 

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

Excel Queries Against Multiple Databases
 

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

Excel Queries Against Multiple Databases
 

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

-----Original Message-----
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


.