Last post May 19, 2015 12:28 PM by Lannie
May 19, 2015 03:58 AM|Sam7|LINK
Please provide me the C# code for exporting more than 5 lakh records in one shot. I tried with my code. I could able to generate only 3 lakh records after that it throws system memory overflow expection
May 19, 2015 12:28 PM|Lannie|LINK
If inserting into XLS there is row limitation of 64,000 rows
If inserting into XSLX there is also limitatons. Usually when the dataset is over 1 gig in size, XLSX does not perform so well.
Even MSACCESS has size limitations when trying to insert data.
so you have 500,000 records and who knows how many cols,
you may very well expect out of memory errors.