Like this:

MS Access exported query expressions usually get truncated at 255
Characters. Instead of exporting the query result directly, insert the
query result into “a table with Memo field”. Then export “the table with
memo field”. The solution detail can be found here: http://support.microsoft.com/kb/178743

Advertisement