Moving data from one Access table to another?

  • Thread starter Thread starter Ryan
  • Start date Start date
R

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.
 
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
 
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.
 
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.
Click to expand...

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