Exporting Memo field to delimited text without field being cut to

P

paulcj

I am attempting to Export an access table containing a Memo field with values
up to 2000 bytes in length. The table contains 121 text fields and the one
memo field which is the 105th field.
I am using the TransferText function in a Macro to export the table to a
pipe (|) delimited text file. When I run the Macro, the Memo field is
concatenated to 255 bytes.
Any help would be greatly appreciated.
 

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

TransferSpreadsheet still truncates the memo field 1
EXPORT QUery with memo field to excel, truncated data 2
Linked table column type changes from text to memo 1
Exporting memo fields from Access to Excel 3
export access memo fileds to excel 1
Removing double quotes from field names 0
Access 2003 memo field truncated while exporting as RTF 0
Access: Memo Fields Being Cutoff When Exporting Reports into Rich 4

Top