Export Memo to txt - truncates at 255

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

JamesSF

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
http://support.microsoft.com/default.aspx?scid=kb;en-us;207668

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

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

thanks in advance

JamesSF
 
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?
 
Back
Top