How do I append only new records while also updating old ones?

[Guest]

I need to append data into a table, but I can't get it to update. I've set a
primary key that avoids duplication, but I also need some way to make sure
that any duplicates are updated within the "Append To" table.

Thanks

 

[Rick Brandt]

I need to append data into a table, but I can't get it to update.
I've set a primary key that avoids duplication, but I also need some
way to make sure that any duplicates are updated within the "Append
To" table.

Thanks

An Append query cannot do updates, but an update query that updates EVERY
field can do appends. You have to use an outer join between the tables so
records in the FROM table that don't exist in the TO table will be added to
it.

 

[[MVP] S.Clark]

An append query ONLY appends. So, after the append, run an update query to
update those records that already exist.