importing text file with carriage return between text qualifiers

[AWetzel]

I'm trying to import a text file into access. The file is tab delimited and uses double quotations as a text qualifier. One of the fields in the text file is a note field and every now and then the person entering the note uses a carriage return (hits the enter key) while doing so. The attachment shows an example of this...




My understanding is that when importing, everything between the two instances of text qualifers should be treated as a single value and the carriage return disregarded. However when I import it the data comes in exactly as it is above which causes field types and column headings to not match up.

Can anyone tell me a way around this short of manually deleting each carriage return?

[RuralGuy]

Your understanding of the import spec double quote escape character is correct and you have probably uncovered a flaw in the parser as the Cr or CrLf sequence is taken as an end of record as well. If is just a Cr and the end of record is CrLf then you might be able to use the Replace() function to assist the import parser.