Array value in a field

[LebronJames]

I am importing an array field into a field within my access database. The field value will show like this:

Vermont, New York Dallas, Texas

Is there a way to say take the values before and after the comma and place them into seperate fields so it shows like this:

Field1 Field2
Vermont, New York Dallas, Texas

 

[PHV]

How should access know that the split is:[tt]
Field1 Field2
Vermont, New York Dallas, Texas[/tt]
instead of:[tt]
Field1 Field2
Vermont, New York Dallas, Texas

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244