Hi Ricardo,

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
try.

Thanks for your suggestion.

J

 --- 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
> 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
> >
> >
>  

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

Reply via email to