Hello everyone,
I'm trying to write a piece of code, which would dump over 65536 records from Access database into Excel spreadsheet. Actually, I've got already couple of versions of this code working. But I can't get to work the most attractive one - using CopyFromRecordset method. In the Visual Studio help on this method there's a statement - "Copying begins at the current row of the Recordset object". So, whenever 65536 records have been copied, I move the current position of the recordset to the current position + 65536 and repeat CopyFromRecordset operation. I know, that recordset did move there, but when I check just copied data, it's like it never did and copying started again from the first record.
So, what do you think might be the problem?
Thank you.
I'm trying to write a piece of code, which would dump over 65536 records from Access database into Excel spreadsheet. Actually, I've got already couple of versions of this code working. But I can't get to work the most attractive one - using CopyFromRecordset method. In the Visual Studio help on this method there's a statement - "Copying begins at the current row of the Recordset object". So, whenever 65536 records have been copied, I move the current position of the recordset to the current position + 65536 and repeat CopyFromRecordset operation. I know, that recordset did move there, but when I check just copied data, it's like it never did and copying started again from the first record.
So, what do you think might be the problem?
Thank you.
