可以,参考这个.你找个Access试验一下.ms-help://MS.VSCC/MS.MSDNVS.2052/cpref/html/frlrfsystemdataoledboledbconnectionclassgetoledbschematabletopic.htmstring strConn = "Provider=SQLOLEDB;Data Source=(local);Initial Catalog=Northwind;Trusted_Connection=Yes;Connect Timeout=11;";OleDbConnection oleDbConnection1 = new OleDbConnection(strConn);
oleDbConnection1.Open();
object[] oa={null, null, null, "TABLE"};DataTable schemaTable = oleDbConnection1.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, oa);
for (int i=0; i< schemaTable.Rows.Count; i++)
{
MessageBox.Show(schemaTable.Rows[i]["TABLE_NAME"].ToString());
}