Anyone know how to get around this problem
I have a CSV file I import into Access using an import spec. I go with comma as the field delimiter. This works fine for most of the records
However, there is a description field as part of the import. If in the description data, there is a comma, then the import thinks this is the end/beginning of the field and everything shifts over 1 field. i have several records that have this problem
Why would anyone think that using a comma as a field delimiter was a good idea, knowing you could have a comma in the data itself.
Anyway, is there a way around this?