Synchronise Data In Access

Hi all,

I hope you might be able to help.

I have today setup an Access database for work as we were using Excel but it has become far too hard to manage.

We receive a list of properties which are empty every month in an Excel spreadsheet. I've managed to import my first set (March) successfully into Access. The idea is that we'll supplement Access with investigation notes etc having one access record per property (each property has its own unique ref. number).

However, next month (April) I'm going to receive a new list of empty properties which will include some from the previous month and some new ones.

I want to import this into Access but tell Access:

- Not to import ones which are duplicated (as there will already be case notes on file). I presume it'll be able to check the unique reference number;
- Insert non-duplicated entries (i.e. any new properties which have come on);

However, I also need to be able to identify those which are no longer empty and mark them as non-empty BUT not delete them (as we need the records on file).

That means that running a report in April will give me the same number of empty properties as the Excel spreadsheet.

Is there a way to do this (not manually as we're talking about 2,000 records per month!) or is it going to become too complicated for Access?

Thanks