>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
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.
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell
