G'day, mate, With MySQL LOAD statement, you can specify which columns of your text file goes to what DB column.
HTH Ignatius _________________________ ----- Original Message ----- From: "JeRRy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 01, 2004 10:08 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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php