title: I'm getting syntax error in insert into statement
body: <p>Could anyone solve the below code plz....</p>
  
  <p>NOTE: front end vb8 &amp; back end access 7</p>
  
  <pre><code>Private Sub SaveData()
      Dim InsertString As String
      InsertString = "Insert into STUDENT DETAILS(SREGNO,SFIRSTNAME,SMIDDLENAME,SLASTNAME,SYEAR,SCOURSE,SSEM,SCLASS,SLANGUAGE)" &amp; "Values('" &amp; Me.TXTSREGNO.Text &amp; "','" &amp; Me.TXTSFIRSTNAME.Text &amp; "','" &amp; Me.TXTSMIDDLENAME.Text &amp; "','" &amp; Me.TXTSLASTNAME.Text &amp; "','" &amp; Me.COMB1SYEAR.Text &amp; "','" &amp; Me.COMB2SCOURSE.Text &amp; "','" &amp; Me.COMB3SSEM.Text &amp; "','" &amp; Me.COMB4SCLASS.Text &amp; "','" &amp; Me.COMB5SLANGUAGE.Text &amp; " ');"
      Dim InsertCommand As New OleDbCommand(InsertString, Con)
      InsertCommand.ExecuteNonQuery()
      MsgBox("New record added successfully.", MsgBoxStyle.Information, "Record Added")
  End Sub
  </code></pre>