We help IT Professionals succeed at work.

Access data base

gkcr
gkcr asked
on
I have two different  access customer data bases functioning seperately .Now I need to add customer data from one of the dada bases to the another.Please advice
Comment
Watch Question

Top Expert 2016
Commented:
the easiest way is to create a link to the table you want to get additional records.

file > external data > link

after you created the link, you can simply create an append query to get the new records
Top Expert 2016
Commented:
assuming you have db A and db B, and the information you want to get is on db B
  run this append query from B

insert into tablex in 'c:\folderName\A.mdb'
select tableB.*
from tableB
Scott McDaniel (EE MVE )Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014
Commented:
To expand a bit on what cap said:

You can Link tables from different datasources in the same database, so Cap is effectively saying that you should link BOTH of those tables in the same database. So if I have Table1 in DB_A, and Table2 in DB_B, then I can create DB_C with links to DB_A.Table1 and DB_B.Table2. From there, I can work with both of those tables in DB_C, and query them as needed.

Of course, you can also link DB_A.Table1 into DB_B, or DB_B.Table2 into DB_A if you don't want to create a 3rd database.