Maybe you've tried this and didn't like how it worked but you could try using a sql statement and selecting only the TOP 500 records for 1- 500
(ie. "SELECT TOP 500 * FROM tbl")

Then, if the table has an ID that increments, you could get the id for the 500th record and set the 501-1000 sql statement to something like the following:

"SELECT TOP 500 * FROM tbl WHERE [ID] > 500"

and so on ...

This is just an idea .. maybe it will help ..