Re: How to add an excel file directly to MySQL database using PHP?
| From: | James Holloway | 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/