>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

The first thing I would suggest is to start by only getting the records that exist in one table and not the other, so you don't have to check for existence on each record.