Syntax error in INSERT INTO statement. Runs in Access not in VB

Question

This query runs perfectly in Access 2007 but when I try to execute it in my code I get Syntax error in INSERT INTO statement. Someone please help.

Dim sql1 As String
sql1 = "INSERT INTO CustomerDtl (KioskID, ClientID, Language, SalesType) VALUES ('AD903',1,'English','Wholesale')"
ObjAccess.ExecuteQuery(sql1)

And this is the ExecuteReader function:

Public Function ExecuteQuery(ByVal SQLQuery As String)

        'This Function Executes SQL Statement against connection and returns number of rows affected'

        dbCommand = New OleDbCommand
        Call OpenConnection()

        With dbCommand
            .Connection = dbConnection
            .CommandType = CommandType.Text
            .CommandText = SQLQuery
            .ExecuteNonQuery()
            .Dispose()
        End With

        Call CloseConnection()

End Function

John Woo · Accepted Answer · 2013-07-20 10:54:59Z

2

Langauge is a reserved keyword. escape it by wrapping [ ].

sql1 = "INSERT INTO CustomerDtl (..., [Language], ....) VALUES(...)"

MS Access Reserved Keywords

answered Jul 20, 2013 at 10:54

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

John Woo Over a year ago

consider also using parameters to avoid injection. mikesdotnetting.com/Article/26/…

Collectives™ on Stack Overflow

Syntax error in INSERT INTO statement. Runs in Access not in VB

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related