I am having a table which holds more than 5 lakhs of records.I want
to copy all these records
into a Excel Workbook in such a way that first 60,000 records are
inserted into one sheet then automatically new worksheet is added and
another 60,000 records added and so on the new sheets are inserted for
every next 60,000 records.
I used CopyfromRecordset method but this is of no use as the records
which overflow are not added into new sheet..
numberofrows = Sheets("INDATA").Cells(2,
1).CopyFromRecordset(RSDPrt)
Kindly let me know a method to do this