title: 'DoCmd.TransferSpreadsheet' to export to Excel
body: <p>I need to EXPORT an access table from ACCESS to EXCEL. There are 618499 rows. I tried simple method: right-click - export - excel. It worked only when I choose export with format (without format created blank excel document), but it is not convenient because I'll have to create 10 documents. I tried to use this code but it became red and did not work:</p>
  
  <pre><code>DoCmd.TransferSpreadsheet(
      [acExport],
      [acSpreadsheetTypeExcel12Xml],
      [tab_1],
      ["C:\Users\admin\Desktop\import_2014\final.xlsx"],
      [True])
  </code></pre>
  
  <ol>
  <li>What should I change in it?</li>
  <li>How should I type it in a module.</li>
  <li>Or maybe you can offer another simple solution. </li>
  </ol>