reading into table: comma values and quotes SQL
- by every_answer_gets_a_point
i have a string like this
something = "something, something1, "something2, something else", something3"
i need it to be read into a table like this:
field1 = "something"
field2= "something2"
field3 = "something2, something else"
field4 = "something3"
please notice that the double quotes in the something string signified that the string inside the quotes is to be placed in one field
anyone know how to do this with an insert into statement or some other way? the answer can be purely sql or can be vba with sql.
thanks!
