Dim cn As New ADODB.Connection Dim rs As New ADODB.RecordsetSet cn = New ADODB.Connection cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\1.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"";" Set rs = cn.Open("SELECT * FROM [sheet1$]") Debug.Print rs.GetString()
引用ADO 2.5Private Sub Command1_Click() Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Set cn = New ADODB.Connection cn.CursorLocation = adUseClient cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\f1.xls;Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'" Set rs = cn.Execute("Select * From [Sheet1$]") Set DataGrid1.DataSource = rs
End Sub
谢谢.楼上各位的回复. 看来现在用的这个Function是可行的. Function fileConnectRst(Sql As String, FileName) As ADODB.Recordset '通过Path连接Rst Dim Cnn As New ADODB.Connection Dim Rst As New ADODB.Recordset Cnn.Open "provider=microsoft.jet.oledb.4.0;extended properties='excel 8.0;imex=1';data source=" & FileName Rst.Open Sql, Cnn, adOpenStatic Set fileConnectRst = Rst End Function
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\book1.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[Sheet1$]
实例:
SELECT * into newtable
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\Finance\account.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions
只共参考
Dim rs As New ADODB.RecordsetSet cn = New ADODB.Connection
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\1.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"";"
Set rs = cn.Open("SELECT * FROM [sheet1$]")
Debug.Print rs.GetString()
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Set cn = New ADODB.Connection
cn.CursorLocation = adUseClient
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\f1.xls;Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'"
Set rs = cn.Execute("Select * From [Sheet1$]")
Set DataGrid1.DataSource = rs
End Sub
看来现在用的这个Function是可行的.
Function fileConnectRst(Sql As String, FileName) As ADODB.Recordset '通过Path连接Rst
Dim Cnn As New ADODB.Connection
Dim Rst As New ADODB.Recordset
Cnn.Open "provider=microsoft.jet.oledb.4.0;extended properties='excel 8.0;imex=1';data source=" & FileName
Rst.Open Sql, Cnn, adOpenStatic
Set fileConnectRst = Rst
End Function