I am currently using an Append query then running a find duplicates query so I can remove any duplicates that were created by the Append query.

What I would like to do is have a query that will not overwrite anything that is existing or have a query that will merge existing data and any new data together.

Can anyone help me with this....

Thanks,
JO

Look for duplicates first, then append, just change the look for duplicates query into an append using the same criteria.
HTH

Why not define a unique index so the duplicates won't be appended.