CopyFromRecordset

[Guest]

Using this method only returns 253 records from a SQL
Server2000 database. It stops with an error '3219' Invalid
Operation.

numberOfRows = Sheets("Sheet1").Cells(2,
1).CopyFromRecordset(rstItems)

I have not found any limits on the method.

???

Thanks!