I am looking for a way to mimic the way "Append From" works with a comma delimited file, but instead of reading a text file, I am being passed a single string in this format.

In other words, if I am passed a string that looks like this:
"1234,'ABCDE',678,'FGH'"

What's the easiest way to break up that string into the appropriate fields of a table.


The only way I can think of to accomplish this, without writing the parsing code myself, is to write the string to a text file then use the APPEND FROM command to read it back in. There must be an easy way that won't produce needless drive writes.

Thanks