Results 1 to 6 of 6
  1. #1
    pterpumpkin is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2013
    Posts
    3

    Character Limit Importing Excel Document to Access

    I have been trying to import an Excel document into my Access database using the External Data > Excel wizard.

    Following through the wizard, I get to the screen where I can select what data type I would like for each field. I change these to "Memo" to allow the maximum character limit.

    At this screen, I can see already that the data is being truncated (either that, or there is a limited column size width).

    Once the data has finished importing into Excel, I open up the table and can see that the data has been truncated to 255 characters.

    Before importing the data, I can see that Excel shows all characters in the formula field. There is no truncation.

    I have also tried saving the data from Excel as CSV. Access does not import this correctly and seems to mix up the fields.

    Why is Access doing this if the fields are set to Memo? How can I import the data?

    Thanks,
    Pter.

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529

  3. #3
    pterpumpkin is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2013
    Posts
    3
    Quote Originally Posted by alansidman View Post
    Thanks for you reply.

    I have changed the cell format in Excel to 'General' before importing, i then change the cell format to 'Memo' during the import process, however it still limits to 255 characters.

    The fields with more than 255 characters are before the 25th column.

  4. #4
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    From the site referenced by Alan:
    How could you avoid this particular problem? By cutting and inserting the 36th row of data above the 25th row in the Excel worksheet.
    At least one row that has a field (column) with more than 255 characters MUST be above the 25th ROW, not column.

  5. #5
    pterpumpkin is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2013
    Posts
    3
    Quote Originally Posted by ssanfu View Post
    From the site referenced by Alan:


    At least one row that has a field (column) with more than 255 characters MUST be above the 25th ROW, not column.

    My mistake!

    I actually managed to fix this another way.

    I removed the "@" from the form text box properties and reimported the Excel doc.

    Thanks for you help! Hopefully this helps someone else too.

  6. #6
    brianok is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Aug 2014
    Posts
    1
    Try LONG PATH TOOL!!!

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

Similar Threads

  1. Query exceeds 1,024 character limit
    By EddieN1 in forum Queries
    Replies: 2
    Last Post: 05-20-2013, 08:11 AM
  2. Character limit in form field
    By tanveerksingh in forum Forms
    Replies: 3
    Last Post: 08-22-2012, 11:04 AM
  3. SendObject Message Character Limit
    By kevins in forum Access
    Replies: 9
    Last Post: 07-20-2012, 09:58 AM
  4. Replies: 16
    Last Post: 10-13-2011, 07:52 AM
  5. Text Box control and character limit?
    By Bigdoggit in forum Forms
    Replies: 2
    Last Post: 03-29-2011, 10:05 AM

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
  •  
Other Forums: Microsoft Office Forums