Why not use

Code:
 Do While Not rs.EOF
       
your code


Loop
As for speed reckon an hour to do 8-10k records, it can depend on what you are doing in the Do ... Loop AND on the level of network traffic.

------------------
Matt G
Either [email protected]] or [email protected]

[This message has been edited by gravyboy (edited 02-04-2000).]