best way to read string into a table in ACCESS

Question

i have a string like this

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

i would like to read this string into a table like this:

field1 = "something"
field2 = "something2"
etc

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

Answer 1

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 );