Re: How to insert to DB from txt??? Please help

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" <kelvin_y@decode-ent.com> To: <php-db@lists.php.net> 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: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >