Question

VB问题，提示错误为 InSert into 语句语法错误，这是怎么回事？

Dim SQL_cmd As String
Dim a1 As String
Dim a2 As String
a1 = Text1.Text
a2 = Text2.Text
If Conn.State = 0 Then Conn.Open
SQL_cmd = "insert into user (Id,用户名,密码) values (1,a1,a2)"
Set rs = Conn.Execute(SQL_cmd)

******************
提示错误为 InSert into 语句语法错误，这是怎么回事？

Answer 1

SQL_cmd = "insert into user (Id,用户名,密码) values (1,a1,a2)"
改为
SQL_cmd = "insert into [user] (Id,用户名,密码) values (1,'" & a1 & "','" & a2 & "')"