Eliminate duplicates

[yankinsf]

Hi,
I am an Access rookie!
Here is my question:
I import a excel file into my db each day. The next day’s file has this information plus any new information.
I would only like to import or add(append) the new records into the table in the db.
How can I do this without creating duplicate records but at the same time making sure only new data has been appended to the table?

Please help find a solution.

Thanks
Sam

 

[BNPMike]

If you only have new records then just append them. Access will reject any rows already present from previous loads. This of course assumes you have set a primary key on your table. If you haven't, then you really should for all sorts of reasons.