>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.
Insanity: Doing the same thing over and over and expecting different results.