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
[EMAIL PROTECTED]
"James Holloway" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > 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/
>
>
--
PHP General 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]
