how to export 500000 records into excel [xls] format

Question

Hi sir Tell me the steps to export 500000 records into excel [xls excel 2003 format]. I can able to export 65536 rows. If i export 500000 records i am getting System out of memory exception Kindly give me the solution for this problem.

Pankaj Pandey · Answer

hii i suggest you to use excel 2007 or higher version to store the high volume of rows.

Ravishankar Singh · Answer

Hi Prabhu refer this link: http://support.microsoft.com/kb/120596

Ravi Shekhar · Answer

Hi Prabu Try to use higher version of excel. you can save 500000 or higher data in excel 2007 and higher. Or you can use .csv to store data. Regards Ravi shekhar

Santhosh Kumar Jayaraman · Answer

Its not supported. Check Microsoft;s link http://support.microsoft.com/kb/120596

how to export 5,00,000 records into excel [xls] format