从DataTable C#添加到OLE类型表

string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=path\\to\\database.mdb";
OleDbConnection connection = new OleDbConnection(connectionString);

connection.Open();

OleDbDataAdapter adapter = new OleDbDataAdapter();

OleDbCommand insertCommand = new OleDbCommand();
insertCommand.Connection = connection;
insertCommand.CommandText = "INSERT INTO TableName (Column1, Column2, ...) VALUES (?, ?, ...)";

foreach (DataRow row in dataTable.Rows)
{
    insertCommand.Parameters.Clear();
    insertCommand.Parameters.AddWithValue("?", row["Column1"]);
    insertCommand.Parameters.AddWithValue("?", row["Column2"]);
    // 添加更多参数...

    insertCommand.ExecuteNonQuery();
}

connection.Close();