VB如何调用EXECL的数据?
Private Sub Command1_Click()Dim adoCnn As New ADODB.Connection
Dim adoRst As New ADODB.Recordset
adoCnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\auto.xls;Extended Properties='Excel 8.0'"
adoRst.Open "Select bb From edee where aa='da'", adoCnn, adOpenKeyset, adLockOptimistic
Set Me.MSHFlexGrid1.DataSource = adoRst
End Sub
auto.xls里有个edee的表,我想调出满足aa='da'里的值
简单来说就是怎么调EXECL的值?