>>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.

Thanks for your reply but the table are from different database containers
so i can not select using one statement