将本地计算机上的Excel文件导入SQL Server 2005 [英] Import excel file which is on local machine to SQL server 2005

问题描述

我在本地计算机上有一个excel文件的路径，我想将excel文件的数据导入SQL Server2005.

我已经尝试过此代码，但它给了我错误-

代码:

 字符串 sSourceConStr = "  + textBox1 +  ;扩展属性= " +   \"Excel 8.0; HDR = YES; + \"";
        字符串 dDestConStr =  @" ;


        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 = " ;
                    bulkCopy.WriteToServer(dr);
                }
            }
        } 

错误:
OleDBException未处理.创建文件失败.

帮帮我. -感谢

解决方案

")； OleDbCommand命令= 新 OleDbCommand(sql，sSourceConnection); sSourceConnection.Open(); 使用(OleDbDataReader dr = command.ExecuteReader()) { 使用(SqlBulkCopy bulkCopy = 新 SqlBulkCopy(dDestConStr)) { bulkCopy.DestinationTableName = " ; bulkCopy.WriteToServer(dr); } } }

错误:
OleDBException未处理.创建文件失败.

帮帮我. -谢谢

检查以下链接
使用c#asp.net批量插入 [ ^ ]

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.net[^]

这篇关于将本地计算机上的Excel文件导入SQL Server 2005的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！