plain-text file (.txt) to mysql database
| From: | JeRRy | Date: | Mon, 01 Mar 2004 09:08:06 +0000 |
| Subject: | plain-text file (.txt) to mysql database | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-33213@lists.php.net to get a copy of this message | ||
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