separate values in an access database table field

[boodito]

I have an access database table with 2 fields: first is key, second is text... the text field has values separated by a '/' i.e. for the value 1 of the key field, the value of text field is "A3/B4/C5" what I need is a script to separate the values and put them in another table each in a record so that the result would be 3 new record in the other table with values
(1, A3)
(1, B4)
(1, C5)

 

[RoyVidar]

Seems somewhat similar to thread707-923268, perhaps you're able to make it work with a couple of alterations?

Welcome to Tek-Tips!

Here's a faq on how to get the most out of the membership faq181-2886 - one of the things mentioned, is posting in the right forum. There are seven specific Access fora (check out the forum search at the top)... so for your next Access question... ;-)

Roy-Vidar