Results 1 to 3 of 3
  1. #1
    Join Date
    May 2011
    Posts
    19

    Question Unanswered:

    When I export Microsoft Project Tasks to an Excel Spreadsheet the notes are
    abbreviated. I would like to export the full task notes. The full task notes
    will print, so they must be stored someplace.

    I also tried exporting the full MPP file to an Access DB but once again the
    task notes were abbreviated.

    When I export Microsoft Project Tasks to an Excel Spreadsheet the notes are
    abbreviated. I would like to export the full task notes. The full task notes
    will print, so they must be stored someplace.

    I also tried exporting the full MPP file to an Access DB but once again the
    task notes were abbreviated.
    Last edited by healdem; 06-20-11 at 10:42. Reason: duplicate posting

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    sopunds liek a well known issue with the way memo fields are handled within the JET SQL engine. its very common for the memo datatype to be truncated to 255 characters.

    usually the problem is caused by doing 'something' tot he memo field inside a query, that could be converting case, manipualting the data (eg adding it to other columns). IIRC it can also be banjaxed if its used in a sort.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    please do no duplicate post questions.
    if you think you may have posted in the wrong forum request a modertor moves the posting to what you think is the right forum
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •