Import without duplicates

C

Cheyenne

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
 
M

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
Click to expand...

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"
 
Top