View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
 
Posts: 593
Default 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.

--