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
Thanks for your suggestion.
--- Ricardo Lopes <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, March 01, 2004 9:08 AM
> Subject: [PHP-DB] plain-text file (.txt) to mysql
> > 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
> > the right field. So each field is seperated by a
> > space as shown above. I have about 1000 entries
> > put in and don't think doing each query per line
> > going to be a 5 min job, any suggestions?
> > Thanks!
> > Find local movie times and trailers on Yahoo!
> > http://au.movies.yahoo.com
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit:
Find local movie times and trailers on Yahoo! Movies.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php