Update a Table from another Table without duplicates
Quote:
>I want to update a customer table from another table (sent
>to me from an external source) but if the customer
>information is already in the customer table I don't want
>to update the customer table and create duplicate records.
>I've tried everything and I'm pulling out my hair. I
>appreciate any help!
More information please. How can you tell whether a record is a
duplicate or not? Do you have a unique ID (good) or are you relying on
names and addresses being spelled identically in two independent sets
of data (VERY risky)? Are you trying to update existing records, or
just append new records? Are the two tables in the same format?
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
