Dim adoConnection As New ADODB.Connection
Dim adoRecordset As New ADODB.Recordset
'非 DSN ,ODBC Provider + ODBC Microsoft Excel Driver 连接:
adoConnection.Open "Data Provider=MSDASQL.1;driver=Microsoft Excel Driver (*.xls);DBQ=e:\temp\book2.xls"
'adoConnection.Open "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=e:\temp\book1.xls"
'adoRecordset.CursorLocation = adUseClient
adoRecordset.Open "select * from [sheet1$]", adoConnection, adOpenKeyset, adLockOptimistic
Debug.Print adoRecordset.RecordCount
Do Until adoRecordset.EOF
'For i = 0 To adoRecordset.Fields.Count - 1
Debug.Print adoRecordset.Fields.Item(0).Name
Debug.Print adoRecordset.Fields.Item(0).Value
adoRecordset.MoveNext
'Next i
Loop
Dim adoRecordset As New ADODB.Recordset
'非 DSN ,ODBC Provider + ODBC Microsoft Excel Driver 连接:
adoConnection.Open "Data Provider=MSDASQL.1;driver=Microsoft Excel Driver (*.xls);DBQ=e:\temp\book2.xls"
'adoConnection.Open "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=e:\temp\book1.xls"
'adoRecordset.CursorLocation = adUseClient
adoRecordset.Open "select * from [sheet1$]", adoConnection, adOpenKeyset, adLockOptimistic
Debug.Print adoRecordset.RecordCount
Do Until adoRecordset.EOF
'For i = 0 To adoRecordset.Fields.Count - 1
Debug.Print adoRecordset.Fields.Item(0).Name
Debug.Print adoRecordset.Fields.Item(0).Value
adoRecordset.MoveNext
'Next i
Loop
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货