Tracking Imports

[Neil P]

I am creating a supply management database which allows
spreadsheets of transactions to be imported to it.

I want to be able to keep a track of what has been
imported to ensure that no duplicate data is imported.

The import will only take place once a week.

Look forward to your help

Neil

 

[Joe Fallon]

1. Use primary keys and the imports should get rejected as duplicates.

2. Consider importing to a staging table.
Then run queries or code to copy new data to the real table and bad data to
a Reject table.

3. Get rid of Excel and make every one use Access!
It is multi user for a reason.