syntax error 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.

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.

[NeoPa]

You don't say which version of SQL your "sql database" is. That doesn't help us to help you.

Fundamentally though, you are using some other version of SQL in Access which supports Jet-SQL. Many of these commands and constructs are not supported in Jet-SQL.

Frankly, this doesn't even look like any SQL I've ever seen. You seem to be assigning a set of SQL commands to a string within some sort of code. The only other code I can imagine you using would be VBA and this doesn't look remotely like that either.

Before we can make any sense of this you will need to explain what this is. Both the programming language and the version of SQL.

[gilesy]

Ok well it's oledb 12 not jet, the INSERT statement is taken from the microsoft website which is why i'm confused about it not working. The language is vb.net.

essentially the insert statement should translate into "INSERT INTO table (column name, column name.....) VALUES ('value1', 'value2'......) "

EDIT. Not to worry i fixed it now.

[NeoPa]

@gilesy
Thanks for letting us know. That's always appreciated :)