OdbcConnection、OleDbConnection均可读取mdb文件
OleDbConnection
private static void UseOleDbConnection(string filePath,string sql)
{
var myConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" +
$"Data Source={filePath};" +
"Persist Security Info=True;" +
"Jet OLEDB:Database Password=myPassword;";
using (OleDbConnection myConnection = new OleDbConnection())
{
// 打开OleDb连接
myConnection.ConnectionString = myConnectionString;
myConnection.Open();
// 执行查询
OleDbCommand cmd = myConnection.CreateCommand();
cmd.CommandText = sql;
OleDbDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); // 完成查询操作后关闭连接
// 加载数据到DataTable
DataTable myDataTable = new DataTable();
myDataTable.Load(reader);
}
}