you should maybe try the free dbtools mysql program from
http://www.dbtools.com.br
this can handle text file imports direct into a mysql db , also it can
import or export from excell , access, paradox, foxpro , dbase or odbc data
sources, very handy tool if all you ever use it for is the transfer of
datatype>datatype..
Steven
----- Original Message -----
From: "Kelvin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 04, 2002 4:44 PM
Subject: [PHP-DB] How to insert to DB from txt??? Please help
> Hi everyone,
>
> I have a txt file which is contained the following:
>
> xxxx,aaa,ccc,ddd
> xxxx,aaa,ccc,ddd
> .....etc.
>
> Now, I need to read the data from that file and than insert it into the
> table.
>
> ----insert into Table ("name","pass","phone","somethingelse")
>
> Could someone help me out here, How to write the code?
> I know how to read from a txt file, but I don't know how to separate
the
> data determine by ","
>
> Please help, I'll be very appreciate.Thanks
>
> Kelvin.
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
