How do I create a multivalue column from delimited text in Access 2010?
February 24, 2014 5:44 AM Subscribe
I want to take a comma delimited list of values e.g. "bacon, sausages, eggs" stored as a single text field and store these as selected values in a single multi-value lookup field.
Basically I want a query that goes something like this
INSERT INTO MainTable ( Meats.[Value] )
SELECT Split(MeatsList,", ");
Unfortunately, Split does not seem to work within a query. Does anyone have any ideas? Thanks! :)