Incorrect Syntax in INSERT INTO STATEMENT

gilesy

Hi, I have a ploblem with an insert statement using an access database, I have the same code with a sql database which works but it doesn't seem to work on access. Could someone please help.

Expand|Select|Wrap|Line Numbers

 
 For i = 0 To dg.Rows.Count - 1

            Main.Command.CommandText = "INSERT INTO Diary (Date1, Time, Appointment) VALUES (?, ?, ?)"

            Dim param1 As System.Data.OleDb.OleDbParameter = New System.Data.OleDb.OleDbParameter("Date1", dg(1, i).Value)

            Dim param2 As System.Data.OleDb.OleDbParameter = New System.Data.OleDb.OleDbParameter("Time", dg(2, i).Value)

            Dim param3 As System.Data.OleDb.OleDbParameter = New System.Data.OleDb.OleDbParameter("Appointment", dg(3, i).Value)
 
            Main.Command.Parameters.Add(param1)

            Main.Command.Parameters.Add(param2)

            Main.Command.Parameters.Add(param3)
 
            Try

                Main.Command.ExecuteNonQuery()

            Catch ex As Exception

                MsgBox(ex.Message)

            End Try

            Main.Command.Parameters.Clear()

i get "syntax error in INSERT INTO Statement" i've tried writing the values directly into the command text and that gives me the same error. Am I missing something totally obvious here?

Thanks in advance.

Plater

Access uses slightly different forms of SQL, have you verified that your SQL code will work in access before trying to use it in .NET?

Is this "(?, ?, ?)" a valid way to add parameters?

Incorrect Syntax in INSERT INTO STATEMENT

re: Incorrect Syntax in INSERT INTO STATEMENT

Similar .NET Framework bytes

/bytes/development

/bytes/it

/bytes/about