TransferText export is truncating field

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?
 
S

slickdock

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.
 
S

slickdock

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error When Using TransferText in a Macro 1
Problem creating export spec - "too few parameters" 1
Transfer Text, Export Delimited w/ Number formated to 4 decimals. 1
TransferText Action-tab delimited file 1
Export table to txt file with a variable filename 0
Export a memo field through a query to text file without truncate 1
Error Message Cannot Update Database is Read Only Error 2950 0
Transfer Text from a query with no additional formatting 4

Top