Moving data from one Access table to another?

[Ryan]

I have personell information on several Access tables (same database)-they
all share a SSN. How do I bring info from one table to another so that it
doesn't create a dupliate persons file?

Ex:
table 1.
100 records= SSN / Last / First / Date Hired

table 2.
30 records (some duplicates of table 1 some not)= SSN / Last / First / Date
Hired

I need to transfer the records of those in table 2 to table 1 without making
two records of the people who are already in table 1.

Help please!

Thanks.

 

[Jeff Boyce]

Ryan

You are asking a "how" question ("how do I ...?").

Why? What will having records 'moved' allow you to do? There may be better
ways to accomplish what you are trying to do, if we only knew what that
was...<g>

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Ryan]

I have an existing personnel data base that is incomplete. I am taking tables
from other offices which has some info which I need and some I do not and
trying to populate my database.

 

[pietlinden]

I have personell information on several Access tables (same database)-they
all share a SSN. How do I bring info from one table to another so that it
doesn't create a dupliate persons file?

Ex:
table 1.
100 records= SSN / Last / First / Date Hired

table 2.
30 records (some duplicates of table 1 some not)= SSN / Last / First / Date
Hired

I need to transfer the records of those in table 2 to table 1 without making
two records of the people who are already in table 1.

Help please!

Thanks.

Use the FindUnmatched query wizard. Then turn it into an append query.