Parsing text from a multiline textbox into a SQL insert stmnt 1

[ToeJamNEarl]

Hey guys,

I have a question. I have a multiline textbox on my form and what I want to do is should the user enter data inside the textbox, I want the program to be able to parse each line from the textbox and put said line into an SQL insert statement.

How could I accomplish this? Would be much appreciated. Thank you.


-Diran

 

[zemp]

Look into using the split function. Then loop through the resultant array and concatenate into an insert statement.

zemp

 

[ToeJamNEarl]

thanks zemp.
split into an array worked like a charm