C#,如何将DataTable快速加载到accdb(access)的表中?
// 将DataTable快速加载到accdb的表中
public static void LoadDataTable2AccdbTable(DataTable dt_input, string accdbFilename, string accdbTableName, string password = null)
{
string connectionString = @"Provider= Microsoft.ACE.OLEDB.15.0;" + "Jet OLEDB:DataBase Password=" + PublicDataClass.password + "; Data Source=" + accdbFilename + ";";
//string sqlString = "SELECT * FROM "+accdbTableName +" where 1 =2";
string sqlString = "SELECT * FROM " + accdbTableName; // +" where 1 =2"; // 选择所有横断面数据
using (OleDbConnection conn = new OleDbConnection(connectionString))
{
conn.Open();
OleDbDataAdapter oleDap = new OleDbDataAdapter(sqlString, conn);
OleDbCommandBuilder builder