Unparsable Record

G

Guest

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.
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top