Export to Excel Very Large Amount of Data

Posted by Nismeh under ASP.NET on 4/16/2014 | Points: 10 | Views : 2270 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi,

I want to export too large amount of data (around 1 crore rows or can be more than it) to Excel. I've implemented it using HTTPContext but its not working properly. Can any one suggest me a tool which can help me to do this?

IT KNOWLEDGE IS APPLIED KNOWLEDGE
So Just Do It

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: A2H on: 4/18/2014 [Member] [MVP] Silver | Points: 25

0	You havent mentioned which database you are using. But if you are using sql server then your best option would be to use SQL Server Integration Services(SSIS) . Please check the below links which explains in detail http://oakdome.com/programming/SSIS_DataTransform.php http://sqlserverrider.wordpress.com/2013/02/14/export-sql-data-to-excel-ssis/ Another option is use the SQL Server inbuild Import and Export Wizard. Please refer the below link http://www.mssqltips.com/sqlservertutorial/202/simple-way-to-export-data-from-sql-server/ Thanks, A2H My Blog Nismeh, if this helps please login to Mark As Answer. \| Alert Moderator

You havent mentioned which database you are using. But if you are using sql server then your best option would be to use SQL Server Integration Services(SSIS) .

Please check the below links which explains in detail
http://oakdome.com/programming/SSIS_DataTransform.php
http://sqlserverrider.wordpress.com/2013/02/14/export-sql-data-to-excel-ssis/

Another option is use the SQL Server inbuild Import and Export Wizard.
Please refer the below link
http://www.mssqltips.com/sqlservertutorial/202/simple-way-to-export-data-from-sql-server/

Thanks,
A2H
My Blog

Nismeh, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts