Thought I'd post this extremely simple solution as I wasn't able to easily find it elsewhere. Solution thanks to thealy via BigResouce.com.
Issue:
Memo type table fields (or query generated strings) in excess of 255 characters are complete in Access but are truncated when exported to text file.
Solution:
1) Right click table or query object -> Export -> Text File
2) Select destination path leaving all export options unchecked, click OK
3) In the Export Text Wizard make all your desired export criteria selection and then click Advanced...
4) In the Export Specification, under Field Information:, hover your cursor carefully over (and slightly to the right of) the line that separates the "Field Name" column and the next blank column until you see your cursor go to double line. Then click and drag to reveal the collapsed columns (just like you would in Excel). Keep expanding out the columns until you get to the "Data Type" column.
5) Set the "Data Type" column to "Memo"
6) Click Save As... if you want to reuse the Export Specification and then click OK
7) Back in the Export Text Wizard click Finish
To understand reasons for field truncation within Access (see http://allenbrowne.com/ser-63.html)
Issue:
Memo type table fields (or query generated strings) in excess of 255 characters are complete in Access but are truncated when exported to text file.
Solution:
1) Right click table or query object -> Export -> Text File
2) Select destination path leaving all export options unchecked, click OK
3) In the Export Text Wizard make all your desired export criteria selection and then click Advanced...
4) In the Export Specification, under Field Information:, hover your cursor carefully over (and slightly to the right of) the line that separates the "Field Name" column and the next blank column until you see your cursor go to double line. Then click and drag to reveal the collapsed columns (just like you would in Excel). Keep expanding out the columns until you get to the "Data Type" column.
5) Set the "Data Type" column to "Memo"
6) Click Save As... if you want to reuse the Export Specification and then click OK
7) Back in the Export Text Wizard click Finish
To understand reasons for field truncation within Access (see http://allenbrowne.com/ser-63.html)