Access Db Table questions

[trojnfn]

I received a master employee file that contains 10,000 records. I filtered it
records I need and that is about 2,000 records only. I then inserted that data
into a table and added some new columns and put in data. I run my applications
against this new table. However, the master employee file changes periodically
and for my application to be current, I need to retrieve the file monthly and
filter it out again. What I need to know how to do is how do I compare the new
file with the existing file and check for additons, deletions, and changes, and
update my file accordingly, without touching the new columns that I created.
For example, if the new filetered file contains five new records, I need to add
those to my existing table. If five records in my existing table no longer
existis in the new filetered file, I need to delete those from my table, and if
there any chagnes, ie address, names, etc, I need to update my table with those
changes. How can I do all of this ? Additionally, would it be possible to
produce a report showing me which records were added, deleted, and changed ?

[Dan Bracuk]

One way is to put each new master file into a working table and do your
comparisons between the real table and the working table.

A better method is to get rid of the file and use your database instead.