1,502
社区成员
发帖
与我相关
我的任务
分享
Private Sub Command1_Click()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
cn.CursorLocation = adUseClient
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\1\123.xls;Extended Properties='Excel 8.0;HDR=no;IMEX=1'"
Set rs = cn.Execute("Select * From [Sheet1$] where f1<>NULL")
Set DataGrid1.DataSource = rs
End Sub