Question Locked

Transfer data from one table to another in Access

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I need help on a topic in Access. I have an existing table with people's information. Then I have another table of people's information which is not up to date. For every person in the old table, I would like to check the name in the new table and if present overwrite the fields of the corresponding record in the the old table. I would appreciate it if you could give me an idea. Thanks a lot!

3 replies

by tony hopkinson

well three actually
1) Take a back up of the database
2) Delete all the names that exists in teh table to update

Something Like
Delete From OutOfDate Where Exists(Select uniquename from UpToDate Where upToDate.UniqueName = OutOfDate.UniqueName)

3) Insert the new ones
Insert OutOfDate Select * FromUpToDate

HTHs

This discussion is closed to new replies.