代码如下试试看,应该满足你的要求了Sub ViewFields() Dim cnn As New ADODB.Connection Dim rst As New ADODB.Recordset Dim fld As ADODB.Field Dim cat As New ADOX.Catalog ' Open the Connection cnn.Open _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=c:\Program Files\Microsoft Office\" & _ "Office\Samples\Northwind.mdb;" ' Open the catalog Set cat.ActiveConnection = cnn ' Set the Source for the Recordset Set rst.Source = cat.Views("AllCustomers").Command ' Retrieve Field information rst.Fields.Refresh For Each fld In rst.Fields Debug.Print fld.Name & ":" & fld.Type '或者其它你需要的字段属性 NextEnd Sub
你的这些要求在这个工程的源代码中全部都实现了
我的例子目录如下,你的可能不同
C:\Program Files\Microsoft Visual Studio\MSDN98\98VS\2052\Samples\VB98\visdata我就不细说了
recordset.Fields.Count
recordset.Fields(i).name
recordset.Fields(i).Properties
recordset.Fields(i).type
Dim cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset
Dim fld As ADODB.Field
Dim cat As New ADOX.Catalog ' Open the Connection
cnn.Open _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\Program Files\Microsoft Office\" & _
"Office\Samples\Northwind.mdb;" ' Open the catalog
Set cat.ActiveConnection = cnn ' Set the Source for the Recordset
Set rst.Source = cat.Views("AllCustomers").Command ' Retrieve Field information
rst.Fields.Refresh
For Each fld In rst.Fields
Debug.Print fld.Name & ":" & fld.Type
'或者其它你需要的字段属性
NextEnd Sub