Private Sub Command14_Click() Dim i As Long, ii As Long Dim db As New ADODB.Connection Dim rs As New ADODB.Recordset db.ConnectionString = "provider=microsoft.jet.oledb.4.0;" & "data source=" & App.Path & "\dev.mdb" db.Open rs.Open "select * from traplog", db ii = rs.Fields.Count For i = 0 To ii - 1 Debug.Print rs.Fields(i).Name '字段名 Debug.Print rs.Fields(i).Type '类型 Debug.Print rs.Fields(i).ActualSize '长度 Next i End Sub
Dim i As Long, ii As Long
Dim db As New ADODB.Connection
Dim rs As New ADODB.Recordset
db.ConnectionString = "provider=microsoft.jet.oledb.4.0;" & "data source=" & App.Path & "\dev.mdb"
db.Open
rs.Open "select * from traplog", db
ii = rs.Fields.Count
For i = 0 To ii - 1
Debug.Print rs.Fields(i).Name '字段名
Debug.Print rs.Fields(i).Type '类型
Debug.Print rs.Fields(i).ActualSize '长度
Next i
End Sub