SQL Insert statement not working ...
Posted on 2011-03-02
I've been receiving an error message stating that my Insert statement has a syntax error. I initially had a very complex sql statement and have now stripped it down to a point where I am trying to see if I can either populate a record with two fields. My statement is as follows:
sInsertQry = "INSERT INTO master (last, first) " & _
"VALUES ('Test', 'Sam')"
following my insert string are the following lines of code:
cmd = New OleDb.OleDbCommand(sInsertQry, conn)
Would anyone know why this simple statement would not work? I cannot see any syntax error.