plain-text file (.txt) to mysql database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux