Results 1 to 2 of 2
  1. 07-21-2014, 09:12 AM #1
    narendrabr
    narendrabr is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2013
    Posts
    21

    Getting 'Unparsable Record' Error when importing txt file to Access 2010


    I am trying to import large txt file to access but getting Getting 'Unparsable Record' Error.
    Any help on this please?
    Error Field Row
    Unparsable Record
    		353045
    Reply With Quote Reply With Quote
  2. 07-21-2014, 10:13 AM #2
    John_G
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    On possibility is that the text in that record contains double-quote (") characters as part of the data, as well as using them as field delimiters.

    What is the format of the text file?

    John
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Unparsable Record error while importing data to a multivalue field
    By hesca in forum Import/Export Data
    Replies: 3
    Last Post: 06-13-2014, 08:02 PM
  2. type mismatch when importing Excel file (access 2010)
    By vitordf in forum Access
    Replies: 9
    Last Post: 11-20-2013, 03:16 PM
  3. Error when Importing CSV file to Access 2007
    By narendrabr in forum Import/Export Data
    Replies: 5
    Last Post: 01-08-2013, 02:05 AM
  4. Importing from excel - Unparsable record error
    By jawinterton in forum Import/Export Data
    Replies: 8
    Last Post: 12-08-2011, 02:14 PM
  5. Importing large txt file into Access 2010
    By Jimbo in forum Import/Export Data
    Replies: 6
    Last Post: 06-30-2011, 08:26 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums