title: 'Insert Into' Access 2010 from java
body: <p>I am using Access 2010 and java 6, I am trying to execute this query but it is giving me an error, here is my code:</p>
  
  <pre><code>String sql = "insert into accounts (title , date , amount) values ('titlexx' , '21-01-2014' , 26000) ";
  getConnection().createStatement().executeUpdate(sql);
  </code></pre>
  
  <p>The error I am getting is this:</p>
  
  <pre><code>java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement
  </code></pre>
  
  <p>I don't know where I am going wrong guys.</p>