Dear All,

I have searched a lot at GOOGLE, but i can't found the way to import data from a form textarea into database.

Actually my web page would like to allow the user to export their phone book from excel file or outlook phone book, then import into my database.

I was thinking to provide a textarea for the user to COPY and PASTE their address book from the text file and then my web page will read line by line to store the data into the database.

Example data:

abc, abc@hotmail.com, 999999999

bcd, bcd@hotmail.com, 888888888

i can't find any solution that can read line by line, because normally when the we parse the data from the form textarea. All the text will become string that without the <br>.

Please HELP !!

Thanks.

Try this ...

<%
Dim MyString, MyArray
MyString = request("textareavalue")
MyArray = Split(MyString,vbCRLF)
For i=0 to UBound(MyArray)
response.write myArray(i) & "<br>"
Next
%>

Try using a regular expression to match what you are looking for line by line and store in an array then iterate through the array and input into the database.