title: Syntax error in INSERT INTO statement. ACCESS
body: <p>I dont get it. What is wrong with this query</p>
  
  <pre><code>While _drRemoteData.Read
      Dim _Query As String = "insert into SchedularTicketsData (RemoteDBID,key,Transno,DateEntered,DateUpdated) values (" &amp; _dbrStores.Item("id") &amp; "," &amp; _drRemoteData("Key") &amp; "," &amp; _drRemoteData("TransNo") &amp; ",NOW(),NOW())"
      _cmdExecute = New OleDb.OleDbCommand(_Query, _ConLMS)
      Try
          _cmdExecute.ExecuteNonQuery()
          WriteLog("Ticket number added " &amp; _drRemoteData("TransNo"))
      Catch ex As Exception
          WriteLog("Ticket number not added " &amp; _drRemoteData("TransNo"))
          WriteLog("Error message: " &amp; ex.Message)
          Exit Sub
      End Try
  
  End While
  </code></pre>
  
  <p>Debugger before execution is showing query</p>
  
  <blockquote>
    <p>"insert into SchedularTicketsData
    (RemoteDBID,key,Transno,DateEntered,DateUpdated) values
    (167,28570,28412,NOW(),NOW())"</p>
  </blockquote>
  
  <p>Execution throw me an error : </p>
  
  <blockquote>
    <p>Syntax error in INSERT INTO statement.</p>
  </blockquote>
  
  <p>Screenshot</p>
  
  <p><a href="https://i.stack.imgur.com/tESeW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tESeW.png" alt="Error showcase"></a></p>