Sorry Shadow, I tried your suggestion, but when I select:-
Fields OPTIONALLY enclosed by: “
I import one record which still has quotes. Here is the display after the import and F5:-
3006 “Boots Healthcare Australia P/L” 3007,”Advanced H
Using XTREE to display the csv file in Hex, I can see the EOL is the normal hex 0D0A
I have over 70K records to import from a larger CSV and I would dearly like to get the import to work
as the speed of import is great. I have attached a similar CSV file if it would help.