Unparsable Record

[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?

 

[Chris O'C via AccessMonster.com]

Make a copy of your data file. Cut the bad record out of the copied file and
paste it into its own text file. Import the big copy of the file so you at
least have the rest of the records imported into a table.

Experiment using a copy of the single record file and try to import only some
of the columns until you narrow down which column fails. For instance, in
the copy of the file, delete the last 22 columns and try to import the rest
into a new table. If that fails, delete 11 more columns so only the first 11
columns of that record are in the file and try to import it. If it's
successful, try adding some more columns and import into a new table until
the import fails. Eventually you'll narrow down which column fails.

Chris
Microsoft MVP

 

[Kirk P.]

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.