Well you have a couple options, you could export the Excel file to a
delimited text file and then import into MySQL. You could also just use the
Excel file and import directly into MySQL with the use of MyODBC and MS
Access. That's all I can think of right now. Either way would work fine I
believe.
> -----Original Message-----
> From: Yeong CN [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 02, 2001 10:43 PM
> To: [EMAIL PROTECTED]
> Subject: How to add an excel file directly to MySQL database
> using PHP?
>
>
> 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?
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
