Memo truncates when exporting to .txt file

[Adam Powell]

I have a table with a field of type MEMO. When exporting to a .txt file,
the contents of the field is truncated to about 255 characters. How can I
get it to Export everything in the field?

 

[Joan Wild]

I have a table with a field of type MEMO. When exporting to a .txt file,
the contents of the field is truncated to about 255 characters. How can I
get it to Export everything in the field?

If you have any formatting on that field it will get truncated. See
http://support.microsoft.com/default.aspx?scid=kb;en-us;259893

 

[Michael]

While running the export wizard, click on advanced. You can define a spec to
use each time you want to export. In the Field Information area is a list of
the fields being exported. Double click on the right edge of the field name
header bar as though you want to auto size the width of the field. You may
have to do this twice. This should pop out a property called "SKIP" that
lets you exclude certain fields. Double click between the field name header
bar and the SKIP header bar. The INDEXED property should appear. Repeat this
until you get the DATA TYPE property. Then change the property for the field
with the MEMO type to memo. You can then export up to 32000 characters in
that field. Save the spec. Be sure to "include field names in the first row"
if your export is setup that way.

 

[Joe Fallon]

I think if you use OutputTo then it will truncate - I never use that
feature.
For A2000 and above use TransferSpreadsheet and it should work. It may have
truncated using older versions of Access and Excel. (e.g. 97 and older.)

 

[Ken Snell [MVP]]

Joe is correct...OutputTo will truncate long strings.

Use TransferText for text file, TransferSpreadsheet for EXCEL file.