I have tried just " on its own, and that didn't work - import fails.

example of the content (when the database is set to limit data entries to 9 characters):

"AB123AB"

"AB12 AB"

an example of the import (when the database is set to limit data entries to 8 characters):

"AB123AB

"AB12 AB

above examples are when there is no text qualifier.

With " (1 set of double quotes) it fails.

Also tried the above with the database character limit to 7 , 8 and 9 - still either shows quotes or import fails.

here are 2 example files (as a series of these csv files are being imported)

http://www.sypensions.org.uk/webcomponents/ab.csv

http://www.sypensions.org.uk/webcomponents/b.csv

- it is just the first column which is being imported.

thanks.