Load OWC spreadsheet in batches from recordsets

[rweide]

I need to load a large amount of data (thousands of rows) to spreadsheet
directly from recordset - in separate operations.
I set the rs.PageSize to 500 (loading 500 rows at a time), and used
copyFromRecordset to load it. And it is successful.
When users click a <Next> button, I would set the recordset's PageCount to
2, and use copyFromRecordset (i.e.
Spreadsheet1.ActiveSheet.Cells.copyFromRecordset rs, 500) to load the second
batch - and it still loads the first 500 rows!
What's not right? Please help!