title: How to export into Excel with openrowset function
body: <p>I am trying to export a table into Excel through <code>Openrowset</code> command</p>
  
  <pre><code>INSERT INTO OPENROWSET 
     ('Microsoft.ACE.OLEDB.12.0', 
     'Excel 12.0;Database=c:\Test.xls;','SELECT * FROM dbo.tablename')
  </code></pre>
  
  <p>I am getting an error : </p>
  
  <blockquote>
    <p>'incorrect syntax near )'</p>
  </blockquote>