Syntax error in INSERT INTO statement.

Mar 27 2010 7:09 AM

Hi,

I have a program to communicate with database. One of the functions is to INSERT data into the database, which is giving me a syntax error!

I can't figure out why...

"INSERT INTO Report ('Date', 'Reporter', 'Details') VALUES ('27/1/2010', 'Mark Smith, 11260(S)', 'gfdsgsdfgsdf')"

I also tried it like this:

"INSERT INTO Report (Date, Reporter, Details) VALUES ('27/1/2010', 'Mark Smith, 11260(S)', 'gfdsgsdfgsdf')"

Can someone please help?

Andrew

Answers (13)