Append Query Questions

[erick-flores]

Hello all

I am doing some append queries and I am having this problem. I have an
ODBC and Links tables. Both tables (from ODBC and Links) are the sames.
The ODBC are in the system and the Links are the ones that the customer
will fill out. When I do an append queries to pass the information from
the links to the ODBC everything works fine BUT when the data already
exist in the ODBC (I already pass transfer the data few days ago) it
would obviously give me an error, because its trying to overwrite data.
So I guess I can delete the records I already transfer and then run the
query with the new data, but I dont like it that way it has to be other
way to do this. Is there a way to: If record already exist dont pass it
else pass it???

Any ideas?

Thanks you

 

[pietlinden]

use the find unmatched query wizard and turn it into an append query.