Unparsable Record

  • Thread starter Thread starter Kirk P.
  • Start date Start date
K

Kirk P.

I've got a .csv file (comma separated, text strings wrapped in "") created by
our IT folks. I'm getting the famous unparsable record error when importing
this file into an Access table. I'm aware of the ususal suspects regarding
this error (bad delimiter, text string improperly wrapped, unususal
characters, etc). I'm looking at this data in Wordpad, and knowing the
record it fails on, I don't see anything wrong with it. So I tried simply
importing the first column - skipping all the other columns, and it still
fails on the same record. The total number of records in the .csv file is
196,792, and it is 44 columns wide.

I'm using the text file import wizard in A07, and creating an import spec.
Is there anything else I should try, or any other way to import this file?
 
I tried simply importing 1 column - deleting all the rest. I'm now getting a
Method 'ExecuteTempImexSpec' of object '_WizHook' failed error message.
Trying a different column gets me the same error message.

I'm out of ideas on this one.
 
Back
Top