C#，如何将DataTable快速加载到accdb2013（access）的表中？

最新推荐文章于 2025-05-02 16:28:34 发布

jadesl13

最新推荐文章于 2025-05-02 16:28:34 发布

阅读量3.2k

点赞数 1

CC 4.0 BY-SA版权

分类专栏：编程基础/技巧文章标签： C#

本文链接：https://blog.youkuaiyun.com/bowangting/article/details/87906457

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