Import without duplicates

[Guest]

I need an easy way to import data from one table into one which can't have
any duplicates. I need an "easy" way please as I update this table on a
weekly basis. Thanks

 

[Mike Labosh]

I need an easy way to import data from one table into one which can't have

any duplicates. I need an "easy" way please as I update this table on a
weekly basis. Thanks

You'd have to check to see if this meets your needs, but when I need to do
stuff like that in Access, I "cheat"

1. Create a unique index on whatever combination of columns represents your
uniqueness requirement
2. Import the file
3. Ignore the message about "n records were not imported due to duplicate
violations"