How to Export Access memo field 87,000 bytes

[JosmithTwo]

I'm trying to export to a text file. I have memo fields that are in some cases 87,000 bytes. I've found how to change Export to tell it I'm exporting a memo field, but it asks for a field length. If I use anything greater the 30,000 it won't work.

I'm using Win XP sp3 with Access 2007



Suggestions? I can work in VBA if needed.

[June7]

Review
http://allenbrowne.com/ser-63.html
http://social.technet.microsoft.com/...e-88144d611d71
http://www.rentacoder.com/RentACoder...uestId=1320540

[JosmithTwo]

Review
http://allenbrowne.com/ser-63.html
Been here - followed the links - no help for the 30,000 - one did note a 32,000 memo field limit - out of date...

http://social.technet.microsoft.com/...e-88144d611d71
Been here too. that's how I got up to 30,000 bytes - not the answer

http://www.rentacoder.com/RentACoder...uestId=1320540

I'm at a loss as to why this suggested. Unless I'm missing something, this is a request for a solution and I can find no solution.

Anyone?

[June7]

Review of articles and threads suggested to learn from others experience, even if we learn there is no solution. Since you already tried the only possible solution I could find, perhaps there is none and the only thing left is to understand. The third link shows someone was desperate enough to pay for a solution - did they ever get it - don't know. Are you at that point?

Only thing I can think of is to break up the memo string into smaller segments and save to a temporary table into separate fields. Export that table.