Set db = New Connection db.CursorLocation = adUseClient db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & "你的数据库"Dim Table As Recordset Dim Tablename Dim i As Integer
Set Tablename = db.OpenSchema(adSchemaTables) Do Until Tablename.EOF '循环所有表 Set Table = New Recordset Table.Open "select * from " & Tablename!table_name, db, adOpenStatic, adLockReadOnly For i = 0 To Table.Fields.Count - 1 ' 循环所有字段 Debug.Print Tablename!table_name, Table End If Next End If Tablename.MoveNext Loop Tablename.Close Set Table = Nothing Set Tablename = Nothing
Set db = New Connection
db.CursorLocation = adUseClient
db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & "你的数据库"Dim Table As Recordset
Dim Tablename
Dim i As Integer
Set Tablename = db.OpenSchema(adSchemaTables)
Do Until Tablename.EOF '循环所有表
Set Table = New Recordset
Table.Open "select * from " & Tablename!table_name, db, adOpenStatic, adLockReadOnly
For i = 0 To Table.Fields.Count - 1 ' 循环所有字段
Debug.Print Tablename!table_name, Table
End If
Next
End If
Tablename.MoveNext
Loop
Tablename.Close
Set Table = Nothing
Set Tablename = Nothing