Hi, 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 Access. HTH, -Srini -- http://symonds.net/~sriniram/ ----- 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 M$ > Acess ... but how ??? > > > thanks > > > -- > 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
