Results 1 to 2 of 2
  1. #1
    Chanda is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2015
    Posts
    3

    Truncating data in Memo field

    I'm importing an Excel file into an existing table. All fields are set to "Memo" since the data in some records are quite lengthy, many between 500-1,000 characters. (Answers to survey questions)

    I viewed another thread and someone suggested removing the "@" in the memo properties (under "format"). I've done this, but the data is still being cut off.

    Can anyone offer any suggestions?

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Take a look here, especially the "Exports" section: http://allenbrowne.com/ser-63.html

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Report Truncating Memo Field(s)
    By alexbumgardner in forum Reports
    Replies: 5
    Last Post: 07-18-2014, 11:13 AM
  2. memo field truncating data on form
    By gillianw in forum Forms
    Replies: 11
    Last Post: 06-04-2013, 06:24 AM
  3. Replies: 2
    Last Post: 09-18-2012, 09:46 AM
  4. Query is Truncating Memo Field
    By Huddle in forum Queries
    Replies: 1
    Last Post: 07-24-2012, 02:24 PM
  5. Union query truncating a memo field
    By jpkeller55 in forum Queries
    Replies: 7
    Last Post: 05-27-2011, 02:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums