Thank you that functioned well, it was completed in seconds. I guess my version of a lot of data isn't that much. 🙂

Thank you!!!

pietlinden (8/21/2016)

---

How about doing the UPDATE on matched data, then doing an INSERT. Just do the whole table at once. (So it would have to be imported into a...

pietlinden (8/21/2016)

---

How about doing the UPDATE on matched data, then doing an INSERT. Just do the whole table at once. (So it would have to be imported into a...

Thank you for the help most of the time we are dealing with under 20k records, this client wants there data from the last 12 years which is over 500k...

Thank you I will take a look into this.