如何将数据从Excel导入到ASP.NET C中的sql数据库 [英] how to import data from an excel to sql database in asp.net c#

问题描述

如何将数据从Excel导入到ASP.NET C#中的sql数据库中
我尝试了这个，但是有一个错误.

"The Microsoft Office Access database engine could not find the object ''Sheet1$''.确保对象存在，并且正确拼写了它的名称和路径名.


我尝试链接:
http://www.aspdotnet-suresh.com/2010/09/import-data-from-excel-to-sql-database.html [

how to import data from an excel to sql database in asp.net c#
I try this but have an error.

"The Microsoft Office Access database engine could not find the object ''Sheet1$''. Make sure the object exists and that you spell its name and the path name correctly.


I try the link :
http://www.aspdotnet-suresh.com/2010/09/import-data-from-excel-to-sql-database.html[^]

error in the line:

dReader = cmd.ExecuteReader();

推荐答案

''.确保对象存在，并且您正确拼写了它的名称和路径名.


我尝试链接:
http://www.aspdotnet-suresh.com/2010/09/import-data-from-excel-to-sql-database.html [

''. Make sure the object exists and that you spell its name and the path name correctly.


I try the link :
http://www.aspdotnet-suresh.com/2010/09/import-data-from-excel-to-sql-database.html[^]

error in the line:

dReader = cmd.ExecuteReader();

请任何人帮助我.

please any one help me.

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

有关的更多信息CodeProject搜索 [此处 [

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

More on CodeProject Search[^]

Even more here[^]

尝试使用ASP中的C#将数据从excel导入到SQL Server. NET [ ^ ]
http://csharpdotnetfreak.blogspot.com/2009/04/export-excel- data-sqlbulkcopy-aspnet.html [ ^ ]

Try Google[^] search. It returned around 913,000 results (0.16 seconds) for your query. Top results:
Import Data from excel to SQL server using C# in ASP. NET[^]
http://csharpdotnetfreak.blogspot.com/2009/04/export-excel-data-sqlbulkcopy-aspnet.html[^]

这篇关于如何将数据从Excel导入到ASP.NET C中的sql数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！