Append+Update+Dublicates

[Akcess]

how to append new data to db table and update one field from another, but before that I need to check for duplicates.

[ranman256]

Make a find duplicates query.
use this query in another query ,outer join to the import data to ONLY import the items NOT already there.
Now make it append to the target table.

And/or make it update the items ALREADY there.