title: SQL delete in EXCEL VBA
body: <p>I manage an Excel 2007 sheet using SQL, using the following connection string: </p>
  
  <blockquote>
    <p>Provider=Microsoft.ACE.OLEDB.12.0;Data Source='Invoice.xlsm';Extended
    Properties='Excel 12.0;IMEX=1;HDR=Yes'</p>
  </blockquote>
  
  <p>Everything works just as it should apart from the Delete statement.
  When I try to perform <code>Delete From [tablename$] where code like '1')</code>, I get an error <code>-2147467259 (80004005)</code>.</p>
  
  <p>I can't explain it, since all the other select and insert statements work just fine.</p>