title: system.data.oledb.oledbexception:Syntax error in INSERT INTO Statement
body: <p>I have a Project in VB.NET as follows</p>
  
  <pre><code>Public Class MCARegis
      Dim con As New OleDb.OleDbConnection()
  
      Private Sub MCARegis_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
  
          Dim da As OleDb.OleDbDataAdapter
          Dim dbprovider As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Taher\Documents\Visual Studio 2010\Projects\WindowsApplication1\WindowsApplication1\Database1.accdb;Persist Security Info=False;"
          Me.con = New OleDb.OleDbConnection()
          con.ConnectionString = dbprovider
          con.Open()
          MsgBox("opened")
      End Sub
  
      Private Sub btnadd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnadd.Click
  
          Try
              Dim da As OleDb.OleDbDataAdapter
              Dim dbprovider As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Taher\Documents\Visual Studio 2010\Projects\WindowsApplication1\WindowsApplication1\Database1.accdb;Persist Security Info=False;"
              Me.con = New OleDb.OleDbConnection()
              con.ConnectionString = dbprovider
              con.Open()
  
              Dim sqlquery As String = "INSERT INTO MCA (URno,SName,Fname,CAddress,)" + "VALUES (" &amp; CInt(txtUrn.Text) &amp; ",'" &amp; txtName.Text &amp; "','" &amp; txtFname.Text &amp; "','" &amp; txtCAdd.Text &amp; "');"
              Dim sqlcommand As New OleDb.OleDbCommand(sqlquery)
  
              With sqlcommand
                  .CommandText = sqlquery
                  .Connection = con
                  .ExecuteNonQuery()
              End With
              MsgBox("Record Added")
          Catch ex As Exception
              MsgBox(ex.ToString)
          End Try
  
      End Sub
  
  End Class
  </code></pre>
  
  <p>I am getting an error when i try to add values at the Insert into statement any suggestions on this? 
  system.data.oledb.oledbexception:Syntax error in INSERT INTO Statement at system.data.oledb.command.exceutecommandtexterrorhandling(oledbhresult hr)
  at systems.data.oledb.oledbcommand.executecommandtext(object&amp;executeresult)......</p>
  
  <p>at system.data.oledb.oledbcomamand.executenonquery()</p>
  
  <p>at line 29.</p>
  
  <p>Thanks in Advance....</p>