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:
- Select query into table.
- In design view, change relevant Text fields to Memo fields, because the
SELECT INTO
automatically set them as Text. - Delete all rows from table.
- Add rows from query using
INSERT INTO
. - 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.