导入访问文件时，它给出格式，除了c＃ [英] while importing access file it give format except in c#

问题描述

protected void btnser_Click（object sender，EventArgs e）

{



string excelConnectionString = @Provider = Microsoft.ACE.OLEDB .12.0;数据源= D：\ edi.xlsx;扩展属性=Excel 12.0 Xml; HDR = YES;



string sqlConnectionString = ConfigurationManager.ConnectionStrings [sqlcon]。ConnectionString;



//创建与Excel工作簿的连接

OleDbConnection excelConnection = new OleDbConnection（excelConnectionString）;



//创建OleDbCommand从Excel中获取数据

OleDbCommand cmd = new OleDbCommand

（选择*来自[medi1 $]，excelConnection）;

excelConnection.Open（）;

OleDbDataReader dReader;

dReader = cmd.ExecuteReader（）;



//为SqlBulkCopy创建对象

SqlBulkCopy sqlBulk = new SqlBulkCopy（sqlConnectionString）;

sqlBulk.DestinationTableName =demo;



//这里你可以进行excel和SQL表的列映射

// sqlBulk .ColumnMappings.Add（UserId，UserId）;

//sqlBulk.ColumnMappings.Add(\"UserName，UserName）;

sqlBulk.WriteToServer （dReader）;

}

}

protected void btnser_Click(object sender, EventArgs e)
{

string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\medi.xlsx;Extended Properties=""Excel 12.0 Xml;HDR=YES""";

string sqlConnectionString =ConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString;

//Create Connection to Excel work book
OleDbConnection excelConnection = new OleDbConnection(excelConnectionString);

//Create OleDbCommand to fetch data from Excel
OleDbCommand cmd = new OleDbCommand
("Select * from [medi1$]",excelConnection);
excelConnection.Open();
OleDbDataReader dReader;
dReader = cmd.ExecuteReader();

// Create object for SqlBulkCopy
SqlBulkCopy sqlBulk = new SqlBulkCopy(sqlConnectionString);
sqlBulk.DestinationTableName = "demo";

// Here you can do the column mapping of excel and SQL table
//sqlBulk.ColumnMappings.Add("UserId", "UserId");
//sqlBulk.ColumnMappings.Add("UserName", "UserName");
sqlBulk.WriteToServer(dReader);
}
}

推荐答案

，excelConnection）;

excelConnection.Open（）;

OleDbDataReader dReader;

dReader = cmd.ExecuteReader（）;



//为SqlBulkCopy创建对象

SqlBulkCopy sqlBulk = new SqlBulkCopy（sqlConnectionString）;

sqlBulk.DestinationTableName =demo;



//在这里你可以进行excel和SQL表的列映射

//sqlBulk.ColumnMappings.Add(\"UserId，UserId）;

//sqlBulk.ColumnMappings.Add(\"UserName，UserName）;

sqlBulk.WriteT oServer（dReader）;

}

}

",excelConnection);
excelConnection.Open();
OleDbDataReader dReader;
dReader = cmd.ExecuteReader();

// Create object for SqlBulkCopy
SqlBulkCopy sqlBulk = new SqlBulkCopy(sqlConnectionString);
sqlBulk.DestinationTableName = "demo";

// Here you can do the column mapping of excel and SQL table
//sqlBulk.ColumnMappings.Add("UserId", "UserId");
//sqlBulk.ColumnMappings.Add("UserName", "UserName");
sqlBulk.WriteToServer(dReader);
}
}

这篇关于导入访问文件时，它给出格式，除了c＃的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！