I am using ADO

I have sometime a table of 4000 records how needs to be added to another table

It is possible that one off the records already exits in that table.
In that case i have to replace it

Now i first check if the record exit if not i append it.
Because it are all sub calls, it take a lot off time.

Does someone have an idee to speed this up

Kind regards


Jan Dorresteijn