Ttrying to copy large data in sheet1 but only 65536 records get copied

**aman1234** · 10-21-2014, 09:17 AM

Hi guys

I am writing the following code to copy data from Access database to Excel. the total number of records that get copied are 90000 so .It gives me error message .

but is there anyway to get it done. I mean writing the piece of code to check if sheet1 is full then move to sheet 2 and then sheet3 and so on until all data gets copied.

Please Login or Register  to view this content.

**aman1234** · 10-21-2014, 09:49 AM

sorry would like to correct something as i was using wrong worksheet name thats why it was giving me subscript out of range but as now I have corrected it so it doesn't give me any error message but in sheet "FSL" , it only copies 65536 records and not 90000 records. so would like vba code that will copy rest of the data in sheet2 .

**JOHN H. DAVIS** · 10-21-2014, 10:23 AM

This excerpt from Chip Pearson's website may help.

Please Login or Register  to view this content.

Note: I had to take out the comments because the procedure was too large to post so you may want to visit his website to get the entire code with comments.