如何用从Excel Sheet通过.aspx页面上传的数据替换现有的sql表数据 [英] How to replace existing sql table data with the data uploaded from Excel Sheet through .aspx page
问题描述
Hiii
我在sqlserver DB中有一个表,即EmpSalary,它包含以下列...
EmpID EmpName Jan13 Feb13 Mar13
从excel表中导入。使用C#编程的aspx页面。
现在我想在同一个表中插入另一张Excel表格..
但是现在在将新的Excel工作表插入表格之前,我想删除表格中的所有旧数据并插入新数据。
如何使用C#编程实现这一点。
我不知道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.
这篇关于如何用从Excel Sheet通过.aspx页面上传的数据替换现有的sql表数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!