I have looked and looked and looked, i am trying to insert a string into a Table using the following code:

InsertTest = "Monkey"
strSQL = "INSERT INTO Holder_tbl (Company, PolicyNo) VALUES (" & InsertTest & ",'TEST')"

When i run the SQL code it asks me to enter the Value for "Monkey" but "Monkey" is meant to be the value. Ive been starring at this code for so long i think i might explode, any help would be much appreciated.. if this makes any sense :P

Sus

Dont you hate it when you finally give in to asking then figure it out yourself...

InsertTest = "Monkey"
strSQL = "INSERT INTO Holder_tbl (Company, PolicyNo) VALUES ('" & InsertTest & "','TEST')"

just missing a couple of "Tics"

Why do I receive a syntax error message for this?


DoCmd.RunSQL "INSERT INTO timestamp_data (timestamp) VALUES ('" & timestamp_buffer & "')"

where timestamp_data is the table, timestamp is the field, and timestamp_buffer is the string variable.