Text to columns in Access

[Terpsichore]

Hello all,
I have a datasheet with a list of names stored in a cell, separated by semi-colons. I want to separate that list into separate columns. In Excel, I would use Data/Text to Columns. Is there some sort of Query something that would do that for me in Access?
Please advise!
tia
Angel

 

[Moniker]

Look in Access Help for the SPLIT() function.