Are you getting an Excel2000 file and don't have Excel to open it? Just
have it sent to you as CSV (Comma Separated Values) rather than XLS; that
would be easy to parse. If you have direct access to the MySQL box, copy
the file there and do the import directly. Check the MySQL docs.
A more elaborate way would be to have the Excel file sent with XML markup,
but from the sounds of it you'd be using a sledgehammer to swat flies.
Miles Thompson
At 11:00 AM 6/28/01 +0530, Sharat Hegde wrote:
>Hello,
>
>I have a web site on a Unix environment running PHP 3.0 and MySQL.
>
>I need to convert data in an Excel format to a MySQL database format
>periodically based on the input feed received in Excel format. the
>conversion to MySQL is not a problem at all.
>
>What I need help is to read data from an Excel 2000 format. How do I
>retrieve data from Excel 2000? The data is basically a 2 columnar data with
>currency names and conversion values.
>
>Thanks in advance.
>
>Regards,
>Sharat Hegde
>Phone: 6560360 Ext 4680
>
>
>--
>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]
--
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]
