Hi Claire,
That is kind of hard to answer without actually seeing the data that
fails. Possibly related to strings that contain embedded commas and/or
quotes? If that does not help, post a sample with any sensitive
information
converted to dummy data.
Clifford Bass
"Claire" wrote:
> I am trying to im****t a comma deliminated file from an outside database
into
> access. If I first open it with excel, and then im****t that into
access, it
> works with limited errors- some zip codes do not go through and such,
which
> is no problem. However, if I try to im****t the csv file directly into
> access, I get ~15 unparsable record errors from the table of ~8,500
records.
> Is there a reason that excel would be able to read the csv file, but
access
> isn't? When I looked at the access table, the records with the erors
> im****ted the first ~10 fields, but left the rest blank.
>
> Thanks for any suggestions as to what is going on,
> Claire
|
