OleDbCommand Syntax error in INSERT INTO statement

Question

I'm getting a syntax error in INSERT INTO statement and I can't figure out why. I've checked several different SO questions that were almost exactly the same as my problem and after changing my code this way and that way it still isn't working.

        var cnnStr = String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};", oldDb);
        var cnn = new OleDbConnection(cnnStr);
        cnn.Open();

        //make new access table
        using (OleDbCommand command = new OleDbCommand())
        {
            command.Connection = cnn;
            command.CommandText = String.Format("CREATE TABLE [{0}] ([Tag] string, [Text] string)", newTable + "_Diff");
            try
            {
                command.ExecuteNonQuery();
            }
            catch
            {
                //table already exists
            }
        }

        //fill access table
        using (OleDbCommand command = new OleDbCommand())
        {
            command.Connection = cnn;
            command.CommandText = String.Format("INSERT INTO [{0}] (Tag, Text) VALUES (?, ?)", newTable + "_Diff");
            command.Parameters.Add(new OleDbParameter("Tag", ""));
            command.Parameters.Add(new OleDbParameter("Text", ""));
            for (int i = 0; i < (diffText.Length - 1); i++)
            {
                command.Parameters["Tag"].Value = diffTag[i];
                command.Parameters["Text"].Value = diffText[i];
                command.ExecuteNonQuery();
            }
        }

        cnn.Close();

Creating the table is working so I know there's not a problem with my connection, there's just something it doesn't like about my insert statement.

Karthik Ganesan · Accepted Answer · 2014-06-30 15:36:53Z

4

In your insert command put text inside a square bracket, "text" is a keyword

command.CommandText = String.Format("INSERT INTO [{0}] (Tag, [Text]) 
                                    VALUES (?, ?)", newTable + "_Diff");

also make sure you are including your values with single quote

values ('?','?')

hope this works

edited Jun 30, 2014 at 15:36

answered Jun 30, 2014 at 15:30

Karthik Ganesan

4,2622 gold badges28 silver badges43 bronze badges

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

3 Comments

Mikkel Bang Over a year ago

Ahhhh I thought I had that! I must have taken the brackets out when changing other things. Thanks for taking the time to point that out for me Karthik

Mikkel Bang Over a year ago

I'm trying to select this as the answer but after I click the check mark it takes it away...I'll try again later

Karthik Ganesan Over a year ago

yeah.. I can see my reputation going up and down :(

Collectives™ on Stack Overflow

OleDbCommand Syntax error in INSERT INTO statement

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related