exporting subsets of the data from Access to Excel.

Occasional Contributor

Hi, i have 4million of row in my Access database.

I want to export subsets of my data to excel. i want to export as per below

 

Numb. Of subset              Start row             End Row
1st                                       1                             1,000,000
2nd                                     1,000,001            2,000,000
3rd                                      2000001              3,000,000
4th                                      3,000,001          4,000,000

 

Appreciate if you can help me. 

 

Regards, 

Rizal

0 Replies