Export Memo to txt - truncates at 255



This has got to be easy- but i cannot figure it out

i am trying to export to a txt file data over 255 chars - it keeps
truncating it

I have tried putting the data to a temp table with a memo field, as
suggested in

still truncates when using:

DoCmd.TransferText acExportFixed, "schema", "table", "c:\filename.txt",
False, ""

BUT not when manaually exporting - i can rightclick the table, export, fix -

i need this to work from code automatically - any suggestions?

thanks in advance


John Nurick

How many characters did you allow for the memo field in your export
specification? Are there any line breaks in the data in the memo field?

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