I am using Access 2003, and trying to Ex****t query results in code to
a csv file.
I am using DoCmd.TransferText. When I run the query, there are two
memo fields: Description and CompoundEOString. They both appear
correctly. When I ex****t the file, the CompoundEOString is truncated
to 256 characters. I have tried:
-Ex****ting to xls and csv files from code using TransferText and
TransferSpreadSheet
-Ex****ting to xls files from the Office Tools menu
-Using an ex****t specification (comma delimited)
-Ex****ting from right clicking on the query
All of them truncate the 2nd memo field. Some cases the Description
field is several thousand characters, and it is never truncated.
If I use the Office Tools menu and ex****t to Word, it ex****ts
correctly.
Any help would be appreciated.
John
