TransferText export is truncating field

  • Thread starter Thread starter slickdock
  • Start date Start date
S

slickdock

When I run a TransferText macro with "Export Word for Windows Merge" on a
query, the "memo" field in the resulting .txt file gets truncated. It's not
truncated in the query, so I know its the Export feature that is truncating
it. I have tried Export Delimited in the Transfer Type argument also with the
same problem resulting.

How can I get all the data in my memo field into the txt file?
 
You can separate the query fields into MemoPart1, MemoPart2, etc., using
Left([Part1],255) and Mid([Part2],255,255) and Mid([Part3],510,255) etc.
 
Thank you for your help. It works great!

slickdock said:
You can separate the query fields into MemoPart1, MemoPart2, etc., using
Left([Part1],255) and Mid([Part2],255,255) and Mid([Part3],510,255) etc.

slickdock said:
When I run a TransferText macro with "Export Word for Windows Merge" on a
query, the "memo" field in the resulting .txt file gets truncated. It's not
truncated in the query, so I know its the Export feature that is truncating
it. I have tried Export Delimited in the Transfer Type argument also with the
same problem resulting.

How can I get all the data in my memo field into the txt file?
Click to expand...
Click to expand...
 
Back
Top