Import From Excel: Compare and Delete

[Samnuni]

Hi all, I have set up my database where information will be imported monthly and a report is generated. Each monthly reports might contain information from the previous months and I would like to have those duplicate entries deleted.

I am thinking of having a master table and a temp table where the import information would go and then have a check put into place to sort those entries out. However, I am not sure how to proceed with this implementation. Please help, thanks in advance.

 

[Andrew Fergus]

Hi

If you set up the key(s) in the table such that duplicate entries cannot be entered then you won't need to worry about deleting duplicate entries. When you copy/append the data from the temporary table to the main table, entries where there would be a duplicate key (which can be more than one field) will not be copied across.

Andrew