【求助】sql语句中出现至少一个参数没有被指定值错误
目的是通过ACCESS库中的数据进行查找温度为340时的物性参数并输出到工作表中
Sub 获取物性参数()
Dim cnn As New Connection, rst As Recordset, fld As Field
Dim strSq1 As String, i As Long, strConn As String
strSq1 = "SELECT*FROM [CO278] WHERE [Temperature]='340'"
strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\DELL\Documents\CO2.mdb"
cnn.ConnectionString = strConn
cnn.Open
Set rst = cnn.Execute(strSq1)
With Worksheets("sheet1")
i = 1
For Each fld In rst.Fields
.Cells(1, i) = fld.Name
Next
j = 1
Do While Not rst.EOF
i = 1
j = j + 1
For Each fld In rst.Fields
.Cells(j, i) = fld.Value
i = i + 1
Next
rst.MoveNext
Loop
End With
rst.Close
cnn.Close
Set rst = Nothing
Set cnn = Nothing
End Sub
不知道问题出在那里