如何获取Access的全部表名称？

[TrueOrFales]

RT

[acewang]

你用一个DataGrid将下面的返回的DataTable显示出来即可
------------------------
Public Function GetTables(conn As OleDbConnection) As DataTable
conn.Open()
Dim schemaTable As DataTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, _
New Object() {Nothing, Nothing, Nothing, "TABLE"})
conn.Close()
Return schemaTable
End Function

[CMIC]

用OleDbConnection.GetOleDbSchemaTable 方法，连接Access

public DataTable GetTables(OleDbConnection conn)
{
conn.Open();
DataTable schemaTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,
new object[] {null, null, null, "TABLE"});
conn.Close();
return schemaTable;
}
schemaTable就有Access的全部表名称，用foreach循环一下就能得到表名