best way to read string into a table in ACCESS

i have a string like this

some_string=  "something, something2, something3, something4, etc.."

i would like to read this string 开发者_Go百科into a table like this:

field1 = "something"
field2 = "something2"
etc

what is the best way to do this in vba/sql?

Use the variable in an INSERT query, listing the field names to match up with their location in the string:

INSERT INTO table_name ( field1, field2, ... )
VALUES ( $some_string );