"AA2e72E" wrote ...

I don't have any sample code to hand: I can suggest some ideas.

ADO has a pagesize
(no of rows) property which you can set to 65536 & then loop through the
PageCount property to retrieve all records.

Could you post some code that demonstrates how to this, please?

Many thanks,
Jamie.

--