Importing an excel file

[MrSpoon]

I have a file I wish to import into access every day, I want the duplicates rejected by Access - but when I try to do this it keeps failing the import. I am using access 2003 7 excel 2003.

I have an ID field which is the primary key, but I want this set on the excel side of things ? Is this possible ?

 

[Trevor G]

I have a file I wish to import into access every day, I want the duplicates rejected by Access - but when I try to do this it keeps failing the import. I am using access 2003 7 excel 2003.

I have an ID field which is the primary key, but I want this set on the excel side of things ? Is this possible ?

Welcome to the forum,

you can remove duplicates several ways, one is use the Excel Filter, Advance filter and remove duplicates

Otherwise import your spreadsheet into a temp table in access and then run the query Remove Duplicates, then append the remainder to the table you want.

Try not to work with a Primary Key field in Excel