asked on create new record in Access table based on criteria
I have a table with two fields: sku and related_skus. related skus has numbers separated by a comma, like 1234,5678,4321
So the table looks like this:
What I need to do is add a record for each comma delimited value in related_skus, so the finished table would look like:
Is that possible?
So the table looks like this:
What I need to do is add a record for each comma delimited value in related_skus, so the finished table would look like:
Is that possible?
SQLMicrosoft Access
Last Comment
Bobby Masterson
ASKER
Thanks. I exported the table as an Excel file and tried that... it did add columns for each comma delimited value, but what I need is a new record for each, not column. Like this:
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks very much.
https://support.microsoft.com/en-us/office/split-text-into-different-columns-with-the-convert-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7