Hi,

I often get to this problem while working on different projects. I do take data from external sources and then I need to copy to my database only new records. Good example would be bank statement. I keep all records of bank transactions in excel sheet (or Access table, or plain txt;csv file). Everytime I want to update data, I download new set of data. Usually I can select date range I want to download from the bank. I would like to be able to set approximate range here. Let say if I remember I did last download in february, I could just take date range from January 1 until now. I do not want to try to define precise cut off between two downloads. It is time consuming and boring... I would like to set up some rules while importing so that just unique records would pass.

I was thinking to combine all field values of single row into string and then search if that string exists. However this might be very time consuming. Please note, that I am searching for some method I can apply on multiple data imports, some of them might be 10 000 rows or longer.

I have then thought to use a query to pass unique records only, this might sound as a better choice than above.

Any other methods, ideas?