'引用 ADO & ADOX
Dim adoConnection As New ADODB.Connection
adoConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\excel97.xls;Extended Properties='Excel 5.0;HDR=no';Persist Security Info=False"
Dim adoxCatalog As New ADOX.Catalog
Set adoxCatalog.ActiveConnection = adoConnection
Dim i As Long
Dim j As Long
For i = 0 To adoxCatalog.Tables.Count - 1
For j = 0 To adoxCatalog.Tables.Item(i).Columns.Count - 1
Debug.Print "[" & adoxCatalog.Tables.Item(i).Name & "].[" & adoxCatalog.Tables.Item(i).Columns(j).Name & "]"
Next j
Next i
Dim adoConnection As New ADODB.Connection
adoConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\excel97.xls;Extended Properties='Excel 5.0;HDR=no';Persist Security Info=False"
Dim adoxCatalog As New ADOX.Catalog
Set adoxCatalog.ActiveConnection = adoConnection
Dim i As Long
Dim j As Long
For i = 0 To adoxCatalog.Tables.Count - 1
For j = 0 To adoxCatalog.Tables.Item(i).Columns.Count - 1
Debug.Print "[" & adoxCatalog.Tables.Item(i).Name & "].[" & adoxCatalog.Tables.Item(i).Columns(j).Name & "]"
Next j
Next i
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货