I am using Access 2003, and trying to Export query results in code to
a csv file.
I am using DoCmd.TransferT ext. When I run the query, there are two
memo fields: Description and CompoundEOStrin g. They both appear
correctly. When I export the file, the CompoundEOStrin g is truncated
to 256 characters. I have tried:
-Exporting to xls and csv files from code using TransferText and
TransferSpreadS heet
-Exporting to xls files from the Office Tools menu
-Using an export specification (comma delimited)
-Exporting 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 export to Word, it exports
correctly.
Any help would be appreciated.
John
a csv file.
I am using DoCmd.TransferT ext. When I run the query, there are two
memo fields: Description and CompoundEOStrin g. They both appear
correctly. When I export the file, the CompoundEOStrin g is truncated
to 256 characters. I have tried:
-Exporting to xls and csv files from code using TransferText and
TransferSpreadS heet
-Exporting to xls files from the Office Tools menu
-Using an export specification (comma delimited)
-Exporting 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 export to Word, it exports
correctly.
Any help would be appreciated.
John