Dim Adors As New ADODB.Recordset
Dim Adoconn As New ADODB.Connection
Adoconn.Open "Provider=Microsoft.Jet.OLEDB.4.0 ;Extended Properties=Excel 8.0;Data Source =\\services\全部数据\test\03-4月.xls"
Dim strs As String要写这样的一句语句的话怎么写?:
Adors.Open "select * from [sheet1$] where ***=阿伟"
|
|
这里的列不想access中有列名,excel没有
列名,那怎么个写法哦?
Dim Adoconn As New ADODB.Connection
Adoconn.Open "Provider=Microsoft.Jet.OLEDB.4.0 ;Extended Properties=Excel 8.0;Data Source =\\services\全部数据\test\03-4月.xls"
Dim strs As String要写这样的一句语句的话怎么写?:
Adors.Open "select * from [sheet1$] where ***=阿伟"
|
|
这里的列不想access中有列名,excel没有
列名,那怎么个写法哦?
f1,f2,f3好象有时候实现起来不行,不是很好,icnetcn(yoyo之无双) 说的能把字段名称读出来,怎么个读法啊?