I am pretty new to Access 2000 (or any Access for that matter), but I was wondering if there is a way to extract certain data from a field. I have imported a table from an Outlook folder (we use Outlook to send out survey's), and the data I want to extract is a memo field with the contents of survey replies. At the bottom of the field is a CSV format line that looks like this:
CSV format:
"","","","",""
It is the bottom line with the comma separated values enclosed in quotes. Is there any way to do this with a query; ie, is there any way using SQL to do a split by carriage return into some sort of an array? Or do I need to learn VBA and do it behind the scenes? Any help is greatly appreciated.

Gary B.