Dim cnn As New ADODB.Connection
Dim rs As ADODB.Recordset
Dim ws As Worksheet
Dim ctr As Variant
Private Sub CommandButton3_Click()
Dim rsx As New ADODB.Recordset
Dim sql As String
sql = "update[合同信息$]set" _
& "单位 ='" & 单位.Value & "'" _
& "身份证号= '" & 身份证号.Value & "'" _
& "出生日期= '" & 出生日期.Value & "'" _
& "身份证号= '" & 身份证号.Value & "'" _
& "性别= '" & 性别.Value & "'" _
& "年龄= '" & 年龄.Value & "'" _
& "where 姓名= '" & 姓名.Value & "'"
rsx.Open sql, cnn, adOpenKeyset, adLockOptimistic
Set rsx = Nothing
End Sub
显示的update语法错误是怎么回事?