获取Access数据库中的所有用户表的名称

        /// <summary>
/// 获取Access数据库中的所有用户表的名称
/// </summary>
/// <returns></returns>
        public static List<string> GetUserTableNames()
        {
            OleDbConnection connection = new OleDbConnection(AccessHelper.ConnectionString);

            connection.Open();
DataTable table = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "Table" });
            connection.Close();

            List<string> tableNames = new List<string>();

foreach (DataRow item in table.Rows)
            {
                tableNames.Add(item[2].ToString());
            }

return tableNames;
        }

转载于:https://www.cnblogs.com/2008freestyle/archive/2012/03/18/2405051.html