Tracking Imports

  • Thread starter Thread starter Neil P
  • Start date Start date
N

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
 
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.
 
Back
Top