VBA code to copy first 50000 records from Access table to excelsheet

**aman1234** · 10-21-2014, 10:05 AM

Hi Guys

Can anyone please help me in writing VBA code that will copy first 50000 records from Access table to excelsheet?

Thanks

**Fotis1991** · 10-21-2014, 10:11 AM

what's the difference with this thread?

**aman1234** · 10-21-2014, 10:14 AM

Fortis, that is a different thread. in this I want first 50000 records to be copied acroos excelsheet.

**Fotis1991** · 10-21-2014, 10:20 AM

in your other thread you said:

... 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 thread closed.

Also i have to warning you, for last time, to comply with forum rules.

Re: VBA code to copy first 50000 records from Access table to excelsheet