A fix for truncating memo field to 255 ?

[Du2good]

Hi everyone,
I'm using Access 2003, Excel 2003, and Word 2003.
Trying to export a table or query or transfer a spreadsheet to Excel that has a memo field with greater than 255 characters. The plan is to use the spreadsheet as a merge data source.

Searched for past 3 days, found multiple posts but havn't found a solution that exports the data without it being truncated at 255 characters.

All of the following have been attempted.
Docmd.OutputTo acOutputQuery
Docmd.OutputTo acOutputTable
DoCmd.TransferSpreadsheet

Attempted using File Menu to export the tempTable but the memo field was truncated in this process as well.
File export TempTable

Is there a solution without putting limitations on the memo field? Or am I missing something?
This was a working project until the memo field needed to be added.

Thank you for time & responses.

 

[strongm]

http://support.microsoft.com/kb/294286

 

[Du2good]

Thanks for the reply strongmm.
Good article, I hadn't seen that one. My solution hopefully will be (as I'm building it now) is: Since users are entering data into a form, use multiple text boxes (memo fields) limiting character input to 255 characters. The db should export the memo fields successsfully to Excel. Word should then be able to merge the multiple memo fields.