[RESOLVED] Text file to MySQL

[telmessos]

Hi all,

I need a simple ASP script to move some information from a txt file to a mysql database. The information on the text file is separated by tabs. I want to create a loop to split the each line from the tabs and write each line's result to MySQL database. I tried it but couldn't make it work.

Can anyone send me an example code with some dummy database field names?

Thanks
telmessos

Note: There are 5 tabs on each line and as you can understand 6 fields on MySQL database.

[yamaharuss]

This is for MSAccess but same principle applies, just change your connection

http://www.aspjunction.com/articles/importtext.asp

[telmessos]

thanks for the info. The example splits with | character. I don't know how to split one tab space. do you know ?

[yamaharuss]

Read carefully..

strLinePart = split(strLine,"|") Split each part of the line using the delimiter

Change that character to whatever your delimiter is

[telmessos]

Thanks for help