Urgent Help needed.

I had tried inserting data into Access table but i keep getting the error message

System.Data.OledbException: Sntax error in INSERT INTO statement.
at System.Data.Oledb.oledbcommand.ExecuteNonQuery()

Here is my code..which is rather very simple..

OleDbConnection Myconnection3 = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0 ; User Id=; Password=; Data Source=G:\GODS.mdb");

string sqlcomm = "INSERT INTO output (MRN) VALUES ('" + _mrn + "')";
Myconnection3.Open();
OleDbCommand oledbinsert = new OleDbCommand(sqlcomm,Myconnection3);
oledbinsert.ExecuteNonQuery();
Myconnection3.Close();

Thanks a lot in advance
Deepu

Todeepu,
To have this answered urgently you should post the question in a relevant forum such as C# or Access depending on your best guess at the problem.



======================================
They say, best men are moulded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

I'll shift this to the access forum- where it belongs.

Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee