Relatively new to ASP coding, so have been looking around for code snippets and tutorials on how to do this, but i can't seem to piece it together in working code. Forgive me if the explanation is a little choppy. What i am trying to do is take a text area, split up the data by line and insert each line as a seperate database entry into an Access db. I don't want to use 20 text boxes. :) 

let's just say this is called "mytextarea'

<textarea>
Line 1 - on submit goes to an access row
Line 2 - on submit goes to next row
Line 3 - on submit goes to next row
</textarea>

Now, I discovered could use something like this for the split of the data

Dim strTextArea
Dim arrTextLines

strTextArea = request.form("myTextArea")
arrTextLines = Split(strTextArea,vbNewLine,-1,1)


But, then how do I get the output of that into a variable or perhaps a series of variables for each line entered that Access will recognize as a loop that needs to be entered in a column, row by row? Could someone help me with a code snippet showing an example of grabbing the textarea info with the line by line split, how it's placed in a loop then a variable (I guess :P) then just a fake insert of that variable into a fake database table, populating the db with the array. Just to get an idea, so i can study it and incorporate it? I hope this was clear.
Thanks in advance.

Parsing with join and split - 5/9/1999
http://www.4guysfromrolla.com/webtech/050999-1.shtml - http://www.4guysfromrolla.com/webtech/050999-1.shtml

Passing Arrays from One ASP Page to Another, Part 2 - 10/19/1999
http://www.4guysfromrolla.com/webtech/101999-1.2.shtml - http://www.4guysfromrolla.com/webtech/101999-1.2.shtml

Q5824 I have string values that look like this: "name, age, height" - How do I parse these so I can reference each value?
http://developer.irt.org/script/5824.htm - http://developer.irt.org/script/5824.htm