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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
baltimore31 said:
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
Click to expand...

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.
 
An append query ONLY appends. So, after the append, run an update query to
update those records that already exist.
 
Back
Top