I have a databse in .txt format (I think it's called CVS) that my CGI script accesses, but now I have PHP and MySQL support so I would like to switch from CGI to PHP and MySQL. My databse has over 800 entries so I would rather not input each one so I am hopeing that someone knows an easy way to convert my .txt file MySQL databse.

Before I go any further.. One of the feilds in my databse contains alot more than 255 characters (more around 1000, but it varies between entry) and from my very small tiny bit of PHP and MySQL knowlege I don't know if I can have a feild over 255 characters.

Back to converting... It is delimited (seperated by) a "|" and has seven "feilds" for each entry. Any help is appreciated very much.