我不知道ASP.net如何帮助你，但是这种事情可以通过SSIS轻松完成。

Hiii


I have a table in sqlserver DB namely EmpSalary and it consists of following columns..


EmpID EmpName Jan13 Feb13 Mar13

It is being imported from an excel sheet through .aspx page using C# programming.

and now i want to insert another Excel Sheet into the same table ..

But now before inserting the new Excel sheet into the table, i want to delete all the old data present in the table already and insert the new data.

How to do this using C# programming.

I don't know how ASP.net would help you, but that sort of thing can be done easily with SSIS.