Adding item in Database

[bobby]

Hi there. I have a simple Access database with names and numbers.
I'm trying to add another entry through vb6 but i get a SYNTAX ERROR in INSERT INTO statement.

Please help. What am i doing wrong?




Private Sub cmdAdd_Click()
Dim sql, nam, num As String

nam = InputBox("Enter Name:", "Name")
num = InputBox("Enter Number:", "Number")


sql = "INSERT INTO Contacts (Name, Number) VALUES " & nam & ", " & num

Call con.Execute(sql )

End Sub

Email

[Hemant Pathak]

Hi Boby Please use this Code........... .
Private Sub cmdAdd_Click()
Dim sql, nam, num As String

nam = InputBox("Enter Name:", "Name")
num = InputBox("Enter Number:", "Number")


sql = "INSERT INTO Contacts (Name, Number) VALUES('" & nam & "','" & num & "')"

Call con.Execute(sql )

End Sub

[bobby]

I have tried using the code above, still the same syntax error appears.
What else can I check?

[bobby]

I just found that Name and Number or one of those were pre-defined names in Access causing my problem.
Thanks for the help.