complex insert and vba

[sadiewms]

I'm trying to get data from one table into another. The data in the
first table - Table A - is something like this:

personfn, personln; personfn, personln; personfn, personln

I would like to split the field and then input a new record for each
string into Table B

I'm guessing that I should do this all in VBA (because I can't find
another way to do it)

So I need to:
loop through each field in Table A
split column A on semicolon using split()
loop through array and insert strings into the field in Table B

I'm stuck trying to figure out how to get the data from a select
statement using VBA. I know I can use RunSQL for the insert. I'm also
unsure of how to do loops

My knowledge of VBA is very very limited. Can anyone give me a start?

Thanks!