Export data by 1000 entry’s

Hi All,

I want to export media & product data.But we have huge data while exporting data from HAC and getting server error.Can anyone help me how we can do this by 1000 entry’s at a time and continue for next results.

Or else do you have any better idea to get that data

Note:Export on creation time won’t work because this is a old date data.

Example:

0 to 1000

1001 to 2000

2001 to 3000

3001 to 4000

…..

….

Thank you,

Soma