Re: How to add an excel file directly to MySQL database using PHP?

From: Date: Fri, 03 Aug 2001 09:01:40 +0000
Subject: Re: How to add an excel file directly to MySQL database using PHP?
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-61104@lists.php.net to get a copy of this message
Hi, phpMyAdmin allows you to import comma separated files into your mysql tables (dunno about .csv but certainly .txt files).. http://phpwizard.net/projects/phpMyAdmin/ Also read up on this: http://www.mysql.com/doc/L/O/LOAD_DATA.html as you may eventually need to set up something to enable a client to import data like this.. James "Yeong Cn" <tzeen@lycos.com> wrote in message news:NOHGBPFPOJEABAAA@mailcity.com... > How can I add an excel file with *.xls extension > directly into MySQL database..is it possible to do or > I need to convert it into *.csv format or *.txt format > first? > > > > Get 250 color business cards for FREE! > http://businesscards.lycos.com/vp/fastpath/

« previous php.general (#61104) next »