将数据从Excel工作表导出到SQL表 [英] export data from excel sheets to sql tables

问题描述

我想将我的Excel工作表数据导出到表中..
在我的Excel工作表[$ Marks]中，我有两个字段StuNo，Marks.我想将这些字段值放入已经存在的mytable中....

I want to export my excel sheet data to table..
In my excel sheet[$Marks] I have two fields StuNo,Marks. I want to these fields values into mytable which one is already existed...

推荐答案

Marks]我有两个字段StuNo，Marks.我想将这些字段值放入已经存在的mytable中...

Marks] I have two fields StuNo,Marks. I want to these fields values into mytable which one is already existed...

请参阅以下内容:

http://sujitkumar.wordpress.com/2008 /09/06/export-excel-data-into-sql-server-using-c/ [ http://forums.asp.net/t/1536218.aspx/1 [ ^ ]

Refer these:

http://sujitkumar.wordpress.com/2008/09/06/export-excel-data-into-sql-server-using-c/[^]

http://forums.asp.net/t/1536218.aspx/1[^]

检查这些.

使用ASP中的C#将数据从excel导入到SQL Server. NET [ ^ ]

http://support.microsoft.com/kb/321686 [将数据从Excel导入到SQL Server [ http://csharpdotnetfreak.blogspot.com/2009/04/export-excel- data-sqlbulkcopy-aspnet.html [ ^ ]

如何使用c#.net [

check these.

Import Data from excel to SQL server using C# in ASP. NET[^]

http://support.microsoft.com/kb/321686[^]

Import Data from Excel to SQL Server[^]

http://csharpdotnetfreak.blogspot.com/2009/04/export-excel-data-sqlbulkcopy-aspnet.html[^]

How to import MS Excel data to SQL Server table using c#.net[^]

这篇关于将数据从Excel工作表导出到SQL表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！