Merge two tables

[Scott]

Recently the table has been delete some records by mistakes. Now, I have a
backup of about one-week old table and the latest table with some deleted
records. I would like to merge these two tables by importing the latest
update records and new records to the old table. Can someone give me some
guidance how to accompany this task.

Thanks,

Scott

 

[Guest]

I assume the table has proper ID-keys. In that case you could use an
appendquery. All the records which are already in the table will be skipped.
Records that aren't in the table yet will be added. There are a couple of
things you need to keep in mind: Is this table not related to other tables,
because in that case you might have to update the related tables as well.
Remember before you jump into any action to make a copy of the database
before you actually are going to do some processing.

hth