将本地计算机上的Excel文件导入SQL Server 2005

本文介绍了将本地计算机上的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[^]