Connecting two databases in MS Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible and if so how, to connect two system databases on two servers
into one MS query?

It's possible in MS Access but I don't know how in MS Excel!

Suggestions please...

Thanks
Dean
 
Can you connect the two tables in MS Access and then use MS Query to access
that connected table?
 
Here's a possible workaround.

Create one query off db1 and save the data in an Excel worksheet.

Create a second query off db2 and save the data in another Excel worksheet.

Create a third query which uses those two Excel worksheets as its source data.

Of course, if the records are more than 65000 rows in length you're out of
luck. Maybe then you could save the query results as a .csv file and query
off that. I've never done that before but don't see why it wouldn't work?
 
Back
Top