access表格路徑D:\1.mdb名稱chsyy
時間段date
我想按時間段里date里抽出時間為start到stop的資料到MSHFlexGrid.表格共有42列.
uj5u.com熱心網友回復：
Dim cn As ADODB.Connection, rs As ADODB.RecordsetSet cn = New ADODB.Connection
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\1.mdb"
Set rs = New ADODB.Recordset
rs.Open "SELECT * FROM chsyy WHERE [date] BETWEEN #" & Format(start, "yyyy-mm-dd HH:nn:ss") & "# AND #" & Format(stop, "yyyy-mm-dd HH:nn:ss") & "#", cn
Set MSHFlexGrid1.DataSource = rs
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/118120.html