Re: How to add an excel file directly to MySQL database using PHP?
| From: | Chris Lee | Date: | Fri, 03 Aug 2001 14:40:44 +0000 |
| Subject: | Re: How to add an excel file directly to MySQL database using PHP? | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-61134@lists.php.net to get a copy of this message | ||
I dont mean to be picky but .. ".. allows you to import comma separated
files .. dunno about .csv .."
csv = comma seperated values
so yes mysql can import csv using the LOAD DATA func or user writen php func
:) sorry about pointing that out.
--
Chris Lee
lee@mediawaveonline.com
"James Holloway" <james@towntalk.co.uk> wrote in message
news:20010803085646.4242.qmail@pb1.pair.com...
> 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/
>
>