Truncated memo field on export!

[jnixon]

Hello! I have a problem resulting from some previous issues I had with a memo field, and you can see the original problem here: http://www.access-programmers.co.uk/forums/showthread.php?p=464184#post464184

I'm starting a new thread because I have a somewhat unrelated problem with the same query. I have a memo field that has quite a few characters...as many as 15,000 characters or more! After running some commands to trim the spaces out of the memo field, I'm trying to export a query with the memo field to a text file. The query is a Select query that matches the memo field with the appropriate order detail from another table where each record has the same order number. All of the tables are actually links to tables on a SQL server.

The query works perfectly. But, when I try to export as a tab-delimited text file, the memo field gets truncated after about 512 characters or so. To clarify my steps, I am right-clicking on the query, select Export, select a Text file from the drop-down box, then select Delimited, Tab, Include Field Names on First Row, and the Text Qualifier is {none}. Please help me! I am using Access 2003 SP2. Thanks so much in advance!!

 

[jnixon]

Anyone have any ideas? Thanks.

 

[Rickster57]

trunk

RuralGuy gave a link to this site the other day and may answer your problem

http://www.accessforums.net/ftopic5593.html


You can also try breaking that field up into say a couple expressions in a query using the mid function..
expr1:mid([mymemo],1,500)
expr1:mid([mymemo],501,500)

 

[jnixon]

Hm, I think it's the cleanup that I'm doing on the memo field that is causing it to truncate - see http://www.access-programmers.co.uk/...184#post464184 . I tried querying right from the table, and exporting the field raw, and it exported the entire memo field. But, when I apply anything that changes the field, i.e. remove spaces, etc., it cuts the field down. Dang!!