How to parse a csv string with text qualifiers
"Janelle" wrote ...
I've tried searching previous
posts in both Excel and Access and have found several
alternatives, but they all break if the qualifier is also
part of the text.
FWIW, I queried your text file data (saved as C:\Tempo\db.txt) using Jet sql:
SELECT * FROM [Text;HDR=NO;Database=C:\Tempo;].db#txt
and it was formatted correctly.
Jamie.
--
|