Oops is my face red?

I read it too quickly

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>If you have exclusive use of both tables (and both have indexes) you could set up a relationship between them.
>
>then use a scan loop to scan through your 4000 records inserting into the main table when the pkfield of the main table is empty.
>
>This of course will effectively do 4000 seeks so it may not be much of an improvement.
>
>If you do not have exclusive use then the SQL UPDATE command may be the a route to go down. You will need to use SEEK with this as well however.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>
>Mark -- he was asking about ADO. Your techniques (I think) would require dumps into cursors -- also an option, but probably adding too much overhead.