Getting syntax error in INSERT INTO statement

Question

So I'm receiving this problem, I tried everything. Kinda stuck

My access database design:

ID - AutoNumber
Data - ShortText

And the insert command:

OleDbCommand command = new OleDbCommand();

string sql = "INSERT INTO Table (Data) VALUES (@Data)";
OleDbCommand cmd = new OleDbCommand(sql, connection);
cmd.Parameters.AddWithValue("@Data", "Test");

connection.Open();

try
{
    cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
    MessageBox.Show("err: " + ex);
    throw;
}

connection.Close();

This might be dumb but I'm really lost and I have no idea what to do.

Salah Akbari · Accepted Answer · 2016-06-05 10:50:36Z

3

The TABLE is a reserved keyword so you should change it's name or you should enclose it in square brackets like [Table]:

string sql = "INSERT INTO [Table] (Data) VALUES (@Data)";

edited Jun 5, 2016 at 10:50

answered Jun 5, 2016 at 10:31

Salah Akbari

40k10 gold badges85 silver badges115 bronze badges

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

Collectives™ on Stack Overflow

Getting syntax error in INSERT INTO statement

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related