Unparsable Record

[Kirk P.]

I'm imported a comma delimited file. After import, an ImportError table is
created, and 1 record has a unparsable record error. Opening the source file
in Notepad, the field within the questionable record looks like:

"8101 "O" STREET LINCOLN NE"

It's not liking the quotes around the O. Is there any way to get Access to
accept the record as shown (other than having someone change the record at
the source)? I've tried playing around with the Text Qualifier (' and none),
but changing that makes MORE import errors from other records.

 

[Jeff Boyce]

Kirk

There are NOT "quotes around the O". The first quote precedes the number,
then there's no delimiter/separator between the #### "field" and the O, then
there's another field that contains "Street Lincoln NE".

I'll take a guess that this was supposed to be something like:

8101 O Street
Lincoln NE

(but in a comma delimited format).

Regards

Jeff Boyce
Microsoft Office/Access MVP