添加ACCESS 数据语法错误

[ywp_xr]

Patch_Sql = "insert into F采集照片接收明细表 valuess（'" & County_Label.Text & "','" & PatchCode_Text.Text & "','" & City_Combo.Text & "','" & County_Combo.Text & "','" & GroupName_Combo.Text & "','" & AreaNumber_Combo.Text & "','" & Completion_Date.Text & "','" & Patch_Date.Value.Date & ")"
Patch_Cmd = New OleDb.OleDbCommand(Patch_Sql, Cn)
Patch_Cmd.ExecuteNonQuery()


试了多少都提示insert into 语法错误，可我怎么也找不出来，请高手帮忙。

[xdashewan]

insert into F采集照片接收明细表 valuess（'" & County_Label.Text & "','" & PatchCode_Text.Text & "','" & City_Combo.Text & "','" & County_Combo.Text & "','" & GroupName_Combo.Text & "','" & AreaNumber_Combo.Text & "','" & Completion_Date.Text & "','" & Patch_Date.Value.Date & "‘) 错看就发现两个错误，还有ACCESS是否支持insert省略字段名你最好试下

[ywp_xr]

谢谢，根据你的提示，问题已经解决。

[VB.Net]

建议你先输出sql语录，然后在access中对sql语句进行测试。