[AccessD] Exporting Memo fields to Excel A2003

Jack,

    It is observed that the phenomenon of truncation of memo field content to 255 characters, while exporting from Access to Excel, is not uniform for different methods used for export.

    The position is summarized below:

    1 - Methods permitting successful export of memo field content larger than 255 characters:
    (a) Manual export of query via File > Export.
    (b) Programmatic export of query using DoCmd.TransferSpreadsheet


    2 - Methods resulting in truncation of exported content of memo field to 255 characters only:
    (a) Manual export of query via Tools > OfficeLinks > Excel
    (b) Manual export of form via File > Export
    (c) Manual export of form via Tools > OfficeLinks > Excel
    (d) Programmatic export of query using DoCmd.OutputTo
    (e) Programmatic export of form using DoCmd.OutputTo

    Conclusions:
    If memo fields are involved, export from Access to Excel has to be confined to methods listed at 1 (a) & (b) above, in order to prevent truncation to 255 characters.

    Note - Tests using Excel's CopyFromRecordset method have not yet been conducted. Prima-facie, this method is also expected to be able to handle the memo fields without truncation.

Best wishes,
A.D.Tejpal
---------------

  ----- Original Message ----- 
  From: Drawbridge, Jack: SBMS 
  To: Access Developers discussion and problem solving 
  Sent: Tuesday, September 11, 2007 02:53
  Subject: Re: [AccessD] Exporting Memo fields to Excel A2003

  Exporting Access2003 query containing memo fields >255char to excel2003.
  This worked fine, following the 2003 Help, in late Aug.

  I am running a slightly modified query (more fields) and the export is
  acting in the pre2003 way -Truncating memo fields.
  I have tried very basic query just memo fields where I know the length
  is >255 and this is being truncated also.

  Have shutdown, rebooted; tried compact and repair.

  I  tried exporting to rtf -- that is working - the memo fields are
  exported full length.
   
  Has anyone got some ideas/experience on this?

  jack