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@xxxxxxxxx> To: <php-db@xxxxxxxxxxxxx> Sent: Monday, March 01, 2004 9:08 AM Subject: 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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
