Truncated 255 Text

[JamesSF]

Hello

I am trying to export a table with a memo field using the

DoCmd.TransferText acExportFixed

command. it truncates at 255 char. I can manually export the table, but
using the transfertext command, it truncates.

Any ideas?

Thanks
JamesSF

 

[Wolfgang Kais]

Hello James.

I am trying to export a table with a memo field using the

DoCmd.TransferText acExportFixed

command. it truncates at 255 char. I can manually export the table,
but using the transfertext command, it truncates.

Any ideas?

I've just had a similar problem, using delimited text.
Use an export specification.
I know, I know: when creating an export specification, you can't specify
fieldtypes for the exported fields. But when creating an import
specification, you can!
So first create an import specification declaring the desired field as a
memo field.
Then use the name of that specification when exporting.
It worked for me.