Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Overwrite records
- Thread starter chefboy
- Start date
I assume you have a unique key that determines the duplicates and you have do not allow duplicates in the table definition.
If you append the records from excel the duplicates should kick out into another table (errors).
Write an update query joining on the errors table.
Delete the errors table.
If you append the records from excel the duplicates should kick out into another table (errors).
Write an update query joining on the errors table.
Delete the errors table.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question