Moving data from one Access table to another?


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.
 
Ad

Advertisements

J

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
 
R

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.
 
Ad

Advertisements

P

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top