Problem exporting large amount of data to excel

[hari4u]

Hello,

I've an application where i need to export gridview data to excel.
My code is working fine for small amount of data but for large data.
I'm getting an exception..
Exception from HRESULT: 0x800A03EC

some times it is taking about more than half an hour to export depending on the size of data..
Is there anyway to export it fast and without error.

Thanks,
Hari.

 

[MattP]

How Do I: Transfer Data Into an Excel Worksheet?

 

[LeShine]

Please try to use the method mentioned in this article (Data Export from Database to Excel, PDF and Word for .NET without Automation and Acrobat Reader - CodeProject)
I think that it will be helpful for you!