Truncated 255 Text

  • Thread starter Thread starter JamesSF
  • Start date Start date
J

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
 
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?
Click to expand...

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.
 
Back
Top