Exporting Large Data to Excel or CSV.......Help

[#1]

Dear All,

I need to export large amount of data.............data size is around 30-40 million rows.

But when exporting in CSV or text the data are limited to 1 million rows, Is there any way through which I can export them in multible sheet.

Thanks in advance to all developers..Kindly try to provide some concrete solution today.