• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 355
  • Last Modified:

Is it possible to join 2 tables from 2 different access databases?

Is it possible to join 2 tables from 2 different access databases?
4 Solutions
Rey Obrero (Capricorn1)Commented:
the easiest way, assuming dbA and dbB
create a link from tables in dbB in dbA , or vice versa
you can then treat the link table like local table in your query
EirmanChief Operations ManagerCommented:
You could import a table from one database into another and work from there .... or you could import both of the tables into a new database
silentthread2kSenior Software EngineerAuthor Commented:
How do you create a link?
Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

Yes, it is possible by using a linked table .
Rey Obrero (Capricorn1)Commented:
for A2003 or lower
File > Get external data > link
  locate the other db and follow the wizard, select the tables

for A2007 or A2010
from ribbon
External Data > Access

In addition to linking one of the tables to the other's database, you can also write a query that references the external (not attached) table using the IN keyword.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now