|
楼主 |
发表于 2019-6-22 11:20
|
显示全部楼层
老师,我自己写了个语句,但是老是报update语法不对的错误
Private Sub CommandButton2_Click()
Dim k As Integer
Dim R As Range
Dim d As Integer
Dim s, u, j As Integer
j = ThisWorkbook.Worksheets("Sheet1").Cells(Rows.Count, 14).End(xlUp).Row '自己用了多少行
Set cnn = New ADODB.Connection
cnnstr = "Provider=microsoft.jet.oledb.4.0;" & "extended properties=excel 8.0;" & "data source=F:\ku\ku.xls;"
cnn.ConnectionString = cnnstr
cnn.Open cnnstr
mysheet = "Sheet1"
s = j
For d = 1 To s
sql = "update Sheet1 Set 停电设备=" & ThisWorkbook.Worksheets("Sheet1").Cells(j, 2) & " ," _
& "set 风险等级=" & ThisWorkbook.Worksheets("Sheet1").Cells(j, 3) & "" _
& " where ID=" & ThisWorkbook.Worksheets("Sheet1").Cells(j, 14) & ""
Set rs = New ADODB.Recordset
Set rs = cnn.Execute(sql)
cnn.Close
Set rs = Nothing
Set cnn = Nothing
j = j - 1
Next d
End Sub
我添加了监视后,监视值为sql="update Sheet1 Set 停电设备=110kV贡攀线线路 ,set 风险等级=七级电网事件 where ID=4",实在是看不出来语法哪里错了,能帮忙看一下吗? |
|