Textarea Different Format

Thanks all for your help on that previous question. Now if i can tap your brain once more with something similar. Been reading up on multi-dimensional arrays. All examples seem to have hardcoded arrays.
My data will always be different with really no limits. But i have a format question and how to split this array into two variables. Say I have a text area. I need people to type a name and a number next to each other seperated by a space.

<Textarea>
PETER 1<ENTER>
PAUL 15<ENTER>
MARY 32
</textarea>

Now how can I split NAME and the number next to it, seperated by the space as a delimeter, put name into one array and number into another array and tell my database that I need the number next to that name(which is already in the database) to be placed into the number column next to it's corresponding name.

Although the actual ACCESS database table is a little more complex, essentially, It would look like this for this example before any data was submitted.

NAME      NUMBER
PETER
PAUL
MARY

We need the table to look like this after submit.
NAME NUMBER
Peter      1
Paul       15
Mary      32

I guess I'm asking how do i grab both sets of data submitted in the format described in the text area into two arrays and then into they're own seperate variables that I can call into an INSERT String and then i guess i'll have to figure out how to compare. Man, I'm confusing myself. 

I think this might be clear, if not let me know and I'll try to extrapolate. Thanks all.