Re: read from flatfile and convert

I copied some data from a web page straight into Excel then saved it as tab delimited which allowed me to import it into MySQL. Try opening the file in a spreadsheet program - it might understand the file! Alternatively, if the data was stored in a flat file previously, there must have been a script or program that was able to extract it. You could be cheeky and ask your client if he has it saved in another format! ;o) "R" <r@jumac.com> wrote in message news:000f01c20206$a0ac9740$0a6da8c0@lgwezec83s94bn... > Hey Guys, > Heres the deal, > I have a client who wants me to make a "testimonials" program for him, > Which is no problem till now, but now he has come with some additional > requirments that I dont know how to deal with... > he has a flatfile with a crap load of entries and he wants me to export it > into mySql! > > Do any of you know what function to write to read a record from a flatfile > and write it to the database record for record? > doing it manually will be a pain in the --- but i dont want to lose the > chance for work...:-( > The flatfile was written using perl. > If need be I can give you the MyTestimonialsDB.txt file to screw around > with..... > > As usual, Any help appreciated. > > Kindly reply, > Cheers, > -Ryan. > > /*Don't steal. The government hates competition.*/ > > >