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
|
