MySQL could handle csv format (mostly use , to separate field) by use Load
command (see syntax in manual). If you don't like to use MySQL command
prompt try some client program:-
mysqlfront www.mysqlfront.de
ursql www.urbanresearch.com/ursql
SF
At 21:43 2/8/2001 -0700, Yeong CN wrote:
>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/
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <mysql-thread81486@stripped>
>To unsubscribe, e-mail
><mysql-unsubscribe-sommai=thaithanakit.co.th@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php