Importing/exporting/linking in Access 2002

[ACE_rj78]

I have two database. I'll call db1 and db2. I do almost everything in db1.
In db2, I have information that I would like to have in db1. Instead of
retyping everything into db1 from db2, I want to import/exporting/link one
database to another. Which is the best way and how do I do this?

 

[Guest]

see post of roseannnej78

 

[John Nurick]

The simplest way to make data in db2 available in db1 is by using linked
tables.

In db1, go to File|Get External Data|Link and follow the instructions.

If you want to get data from db2 into an existing table in db1, start by
making a linked table as above. Then create an Append query to append
the data from the linked table to the main table (look in Help for
"create an append query"). Finally, delete the linked table (deleting a
linked table in db1 won't affect db2).