The majority of the problems arise when you try to do something that's not
idiomatic to the language or endemic to the environment. MS Excel & PHP do
not co-exist, and you will have a lot of headaches whenever you try using
some M$ product with a non-M$ technology.
However that being said...here is where I see some hope:
a) Use COM and access MS Excel. Ofcourse your PHP code will not be portable
and you will have to learn to use COM.
b) I'm not sure if Excel is accessible as an ODBC database. IIRC, VB used to
allow me to use MS Excel as a file database.
c) Have the excel file converted to CSV file by some programmatic
means....VB... office macro whatever and then import the CSV via PHP into
----- Original Message -----
From: "Josť Moreira" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 13, 2002 7:04 PM
Subject: [PHP-DB] how is it possible to read data from an excel workbook ?
> i need to read data from a sheet in M$ Excel to update some databases in
> Acess ... but how ???
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php