Seperating string into multiple fields

[onikage1]

Ok here goes,

I have a field that's a string, something like


64356_5463645_45364636

Sometimes there's 4 sets, 5 sets, 2 sets, etc. of numbers. What I need to do is to split each of these numbers up into their own fields.

I've seen a few ways to do it but none that work with my current setup. I'm using Access as a stand alone database, nothing on the back end.

Any and all suggestions are certainly appreciated

[shamshe]

Export table to the csv file using "_" as delimiter and set Text Quilifier to none. Then import this file back into the database using "_" as delimiter