本文介绍了将本地计算机上的Excel文件导入SQL Server 2005的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在本地计算机上有一个excel文件的路径,我想将excel文件的数据导入SQL Server2005. 我已经尝试过此代码,但它给了我错误- 代码:
字符串 sSourceConStr = " Provider = Microsoft.Jet.OLEDB.4.0;数据源=" + textBox1 + " ;扩展属性= " + " \"Excel 8.0; HDR = YES; + \""; 字符串 dDestConStr = @" server = severIPAddress; database = databaseName ; uid = userName; password = pwd"; OleDbConnection sSourceConnection = 新 OleDbConnection(sSourceConStr); 使用(sSourceConnection) { 字符串 sql = 字符串 .Format(" 选择* FROM [{0}]"," Sheet1 $"); OleDbCommand命令= 新 OleDbCommand(sql,sSourceConnection); sSourceConnection.Open(); 使用(OleDbDataReader dr = command.ExecuteReader()) { 使用(SqlBulkCopy bulkCopy = 新 SqlBulkCopy(dDestConStr)) { bulkCopy.DestinationTableName = " dbo.databaseName" ; bulkCopy.WriteToServer(dr); } } }错误: OleDBException未处理.创建文件失败. 帮帮我. -感谢
解决方案"); OleDbCommand命令= 新 OleDbCommand(sql,sSourceConnection); sSourceConnection.Open(); 使用(OleDbDataReader dr = command.ExecuteReader()) { 使用(SqlBulkCopy bulkCopy = 新 SqlBulkCopy(dDestConStr)) { bulkCopy.DestinationTableName = " dbo.databaseName" ; bulkCopy.WriteToServer(dr); } } }
错误: OleDBException未处理.创建文件失败. 帮帮我. -谢谢
检查以下链接 使用c#asp批量插入 [ ^ ]
I am having a path of excel file which is located on my local machine and i want to import the data of excel file to SQL server 2005. I have tried this code but it gives me error- Code:
string sSourceConStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + textBox1 + "; Extended Properties=" + "\"Excel 8.0;HDR=YES;+\""; string dDestConStr = @"server=severIPAddress;database=databaseName;uid=userName;password=pwd"; OleDbConnection sSourceConnection = new OleDbConnection(sSourceConStr); using (sSourceConnection) { string sql = string.Format("Select * FROM [{0}]", "Sheet1$"); OleDbCommand command = new OleDbCommand(sql, sSourceConnection); sSourceConnection.Open(); using (OleDbDataReader dr = command.ExecuteReader()) { using (SqlBulkCopy bulkCopy = new SqlBulkCopy(dDestConStr)) { bulkCopy.DestinationTableName = "dbo.databaseName"; bulkCopy.WriteToServer(dr); } } }Error: OleDBException was unhandled. Failure creating file. Help me out. -Thanks
解决方案 "); OleDbCommand command = new OleDbCommand(sql, sSourceConnection); sSourceConnection.Open(); using (OleDbDataReader dr = command.ExecuteReader()) { using (SqlBulkCopy bulkCopy = new SqlBulkCopy(dDestConStr)) { bulkCopy.DestinationTableName = "dbo.databaseName"; bulkCopy.WriteToServer(dr); } } }Error: OleDBException was unhandled. Failure creating file. Help me out. -Thanks
check below link bulk insertion using c# asp[^]更多推荐
将本地计算机上的Excel文件导入SQL Server 2005
发布评论