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.