Creating a Duplicate Finder

[oodai]

Dear Experts,


seeking help on a problem which I do not have clue on how to create butcould be a walk on the cake for the experts
every day I receive an excel file with below details (4 columns) and I havehistoric data for 2 years (50K Lines)
1. Customer Number (CN)
2. Receipt Number (RN)
3. Receipt Amount (RA)
4. Receipt Date (RD)
I would need help in creating the below
As soon as I receive the daily excel file
1. Upload the file to the existing master (50K) lines
2. Check for possibility of duplicates from below scenarios
  CN& RN& RA& RD
   CN& RN& RA
   CN& RN& RD
   CN& RA& RD
   CN& RN
   RN& RA
   CN&RA
3. Populate the potential duplicates for the above scenarios
4. Able to view and click on delete for any of the possibility
5. show a count of data that has been deleted till now
if somebody can guide e on how do I achieve this in Access please bear inmind i have never got an opportunity to work on access.
I know I am asking for too much but it would be a life saver for me and willbe agreat learning point for access
thanks a lot!!!

[ranman256]

save the excel files as a generic name everytime, say: file2Import.xlsx
every new file you get , save it and overwrite the existing one
attach the excel file as a table.
create an append query to import the excel table. If you want to eliminate duplicates in the excel file, set the query to UNIQUE VALUES = true
Now only unique records will import.
put this query in a macro.

the steps to import will then be:
1 save excel file to file2import.xlsx
2 run import macro
done.

If you need to find duplicates in the internal data table, create a find duplicate select query.
use the query wizard to build it.

when the query opens, delete any duplipicates.