Author: nitinbande | Posted on: 4/8/2009 10:13:00 AM | Views : 465

Hello,
This is Nitin,

I hope all of you are doing good. I liked this Website which helps us in solving problems.
 Actually I have Problem regarding Excel file upload in ASP.NET 2.0.
Here I am uploading .CSV file on the server using File Upload. then we are reading the file and storing its data into the database(SQL database).
It works fine on test server but the same code on the production server crashes the website for long time.

can anybody knows the solution for this?

Here is the code.....

        Excel.Application app = new Excel.ApplicationClass();
        Excel.Workbook workBook = app.Workbooks.Open(pathfile, 0, true, 5, "", "", true,
            Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);

    ...

Go to the complete details ...