title: how to export query to Excel without truncating Memos to 255 chars?
body: <p>Using Access 2010.  I have a query with several Memo fields in it that I would like to export to an Excel sheet.  Every method I have tried so far has truncated the Memo fields:</p>
  
  <ul>
  <li>Export Wizard</li>
  <li>Right-clicking on the query and choosing Export</li>
  <li>Exporting to CSV</li>
  <li><code>DoCmd.TransferSpreadsheet</code></li>
  <li>Copy/pasting the data into open Excel sheet</li>
  </ul>
  
  <p>How can I get all the Memo data in my export, or at least the full 32767 characters that an Excel cell can display?</p>