how to export query to Excel without truncating Memos to 255 chars?

Export into excel with option "Export data with formating and layout" set to YES. If this checkbox is not set to yes, access truncate texts to first 255 characters.

enter image description here


Adaam's suggestion was very helpful. I ended up doing this the following way:

  1. Select query into table.
  2. In design view, change relevant Text fields to Memo fields, because the SELECT INTO automatically set them as Text.
  3. Delete all rows from table.
  4. Add rows from query using INSERT INTO.
  5. Import table contents into Excel range using Range.CopyFromRecordset. I had to do this from the table instead of directly from the query because I had UDFs in my query.