how to display excel sheets on aspx page for dataEntry

Question

please help me.... how can i display excel sheets on my aspx page for data entry from users and save these value in sql database... i am using the SQL dataabse 2005 Visual Studio 2008 with C#

paul daniel · Answer

Hi Refer this link http://www.beansoftware.com/asp.net-tutorials/generating-excel-reports.aspx

Andrew Fenster · Answer

The short answer is that you shouldn't do it. There are lots of articles about how to use Excel or Word on the fly inside a web application. Microsoft however recommends that you NOT do this. See http://support.microsoft.com/kb/257757 . The big problem is that this causes memory leaks slow performance and crashes. So Nikhil's suggestion is correct. Have them enter the data in a GridView or other data control.