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?
 
Fraid not, I don't have MS Access. I've just seen it done on someone else's
machine!
 
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?
 
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

help returning the same values from two different cells 1
Conditional MS Query 1
Excel Barcoding using a central database repositories 0
Am I disturbing a machine in production floor if I access its database remotely? 4
Counting multiple memberships 1
Difference in size of actual access database and its backup 0
MS Query keeps getting Out of Memory messages 1
MS Query DateTime String 1

Back
Top