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

Is there really any value in doing so? While in Access you can work
effectively with very big numbers of records, this is more than I can
say for Excel, especially if your data spans over multiple sheets. I
suggest you consider working with Access instead.

While Excel may be some sort of a software Swiss Army knife, you
wouldn't consider cutting down a 100ft oak with it when you have a
chainsaw available, would you?

HTH,
Nikos