20lakhs records export issue from access to excel

[Ravi Kumar 22]

Hi,

I have 20lakh records in single access file, how to export data to 2 or 3 separate excel in single shot

[jimatqsi]

Ravi, not sure what you are trying to write there. I suppose you are telling you have a lot of records in a single table that you would like to export into several Excel sheets, with 1/3 of the records in each Excel sheet?

What do you mean by "single shot?" You want to press a button on a form to make this happen? Or do something with a macro? Are you able to write VBA code? The only way I imagine you can do this is going to require some VBA making multiple calls to TransferSpreads heet.

You'll find lots of good help here if you give us a good, clear explanation of what you're trying to do.

Jim