A simple SQL question

[tzachari]

Hi All,
I have 3 text boxes in my VB app and I want to insert the values in this text box into a access 97 table using ADO code. I am getting an SQL syntax error. I am really not familiar using SQL within VB.

I have already established the connection to by db. Here is a part of the code

Public objCmd As New ADODB.Command

objCmd.CommandType = adCmdText

objCmd.CommandText = "INSERT INTO Table(FName,LName,City)Values(Text1.text,text2.text,text3.text)

objCmd.Execute

I am getting a "Insert into" SQL syntax error. Please help

Zack

[JHausmann]

try replacing:

objCmd.CommandText = "INSERT INTO Table(FName,LName,City)Values(Text1.text,text2.text,text3.text)



with

objCmd.CommandText = "INSERT INTO Table(FName,LName,City)Values('"Text1.text" & "','" & text2.text & "','" & text3.text & "')"