Results 1 to 7 of 7
  1. #1
    Alaska1 is offline Advanced Beginner
    Windows Vista Access 2003
    Join Date
    Oct 2010
    Posts
    55

    Importing Large Text Files from Excel into Access

    I have a data file I am importing into MS Access 2010. One of the fields is a large text field. When i import that field into Access the text is getting cut off. How do I get the full text field to import without cutting off?

  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
    Have you tried importing the file into an existing table and for the field you are having issues with format it as a memo field and not a text field. Text fields can only handle 255 characters. Memo fields can handle around 18,000.

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Actually, an Access 2010 memo field can handle a lot more. I knew about the 65.536 bytes; I didn't know about the size when entering data programmatically

    Number of characters in a Memo field (from http://office.microsoft.com/en-us/ac...010341462.aspx)
    65,535 when entering data through the user interface;
    1 gigabyte of character storage when entering data programmatically

  4. #4
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Thanks for the update Steve. I was not aware of the new parameters. But, I can't even remember the last time I worked with a memo field. Maybe three or four years.

  5. #5
    Alaska1 is offline Advanced Beginner
    Windows Vista Access 2003
    Join Date
    Oct 2010
    Posts
    55
    Quote Originally Posted by Alaska1 View Post
    I have a data file I am importing into MS Access 2010. One of the fields is a large text field. When i import that field into Access the text is getting cut off. How do I get the full text field to import without cutting off?

    Thank you for your quick response. I will try the memo field. The field was importing as a text field.

  6. #6
    Alaska1 is offline Advanced Beginner
    Windows Vista Access 2003
    Join Date
    Oct 2010
    Posts
    55

    Text still cutting off

    Quote Originally Posted by Alaska1 View Post
    I have a data file I am importing into MS Access 2010. One of the fields is a large text field. When i import that field into Access the text is getting cut off. How do I get the full text field to import without cutting off?
    I setup the field name in access as a memo field but the text is still cutting off at 255.

  7. #7
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Have you tried saving your excel file as a .csv file and importing that. If you do it that way, you have more control over the import specs. When using the wizard to import, click on the advanced button during the process. You will now have the opportunity to specify the field types. Be sure to make this particular field a memo. If this is a regular importation and not a one time event, you can even save the import specifications for future use.

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

Similar Threads

  1. run-time error 70 when importing text files from software
    By mejia.j88 in forum Import/Export Data
    Replies: 6
    Last Post: 06-05-2012, 04:10 PM
  2. Importing Text files
    By RayMilhon in forum Programming
    Replies: 4
    Last Post: 10-10-2011, 10:54 PM
  3. Importing large txt file into Access 2010
    By Jimbo in forum Import/Export Data
    Replies: 6
    Last Post: 06-30-2011, 08:26 PM
  4. Replies: 1
    Last Post: 02-21-2011, 09:55 PM
  5. Cannot import excel or text files
    By donald_s in forum Access
    Replies: 2
    Last Post: 04-13-2010, 11:48 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