i have a string that i need broken up into rows
ID EMAIL
33455 1@yahoo.com,2@yahoo.com,3@yahoo.com,4@yahoo.com,5@yahoo.com,6@yahoo.com,7@yahoo.com,8@yahoo.com
is that possible? i know how to split it and get each value, but don't know how to insert it into a table one at a time
besides inserting each value, i also have to insert the ID, so for each row i have to insert one email address and the id, and repeat it 8 times
number of email addresses is always different
thank you
ID EMAIL
33455 1@yahoo.com,2@yahoo.com,3@yahoo.com,4@yahoo.com,5@yahoo.com,6@yahoo.com,7@yahoo.com,8@yahoo.com
is that possible? i know how to split it and get each value, but don't know how to insert it into a table one at a time
besides inserting each value, i also have to insert the ID, so for each row i have to insert one email address and the id, and repeat it 8 times
number of email addresses is always different
thank you