Re: plain-text file (.txt) to mysql database

Hi Ricardo, Yep that is why I asked for website/Program already established. Don't have the time to do what is mentioned as this is very urgent and needs to be done quicker rather than later. Short notice posting I know but anything is worth a try. Thanks for your suggestion. J --- Ricardo Lopes <lopes@elevaconsult.pt> wrote: > I know this might sound a little bad, but i would > use Perl or an editor that > supports regulars expresions to convert the data > into insert statements and > after that i would use a database administration > tool (ex. myCC) to insert > the data, you could put some statements before doing > the inserts to disable > foreign key checks and others things to speed up the > process, but in your > case i think this would have no effect in the speed. > > > ----- Original Message ----- > From: "JeRRy" <jusa_98@yahoo.com> > To: <php-db@lists.php.net> > Sent: Monday, March 01, 2004 9:08 AM > Subject: [PHP-DB] plain-text file (.txt) to mysql > database > > > > Hi, > > > > Quick question, does anyone know of a program/site > > that could do the following: > > > > I have a .txt file written in notepad. > > > > Bob Someone Mr > > > > Now I have a db with the fields: > > > > First Last Title > > > > Now the .txt file looks something like this: > > > > Bob Someone Mr > > Susan Taylor Miss > > Andrea Nothing Ms > > ... > > > > Now I want to use a Program/site to put the names > in > > the right field. So each field is seperated by a > > space as shown above. I have about 1000 entries > to > > put in and don't think doing each query per line > is > > going to be a 5 min job, any suggestions? > > > > Thanks! > > > > Find local movie times and trailers on Yahoo! > Movies. > > http://au.movies.yahoo.com > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: > http://www.php.net/unsub.php > > > > > Find local movie times and trailers on Yahoo! Movies. http://au.movies.yahoo.com