Re: [PHP-DB] how is it possible to read data from an excel workbook ?
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 meansVB... 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
RE: RE: [PHP-DB] how is it possible to read data from an excel workbook ?
thanks for your attention the question is that im 'working' on a software to automate a weekly employee task that resumes to import a excel file that comes in zip format from the mother-company with new prices and products, to update an accounting software that uses M$ access db. there are already access databases that import the file, merge the new data with the old and update the databases ... ( i made a vb aplication to fire up the databases in the right sequence ) but its very complicated to the person in question so i thinked of a php aplication to upload the file and replace the work made by Acess -Mensagem original- De: Jeremy Peterson [mailto:[EMAIL PROTECTED]] Enviada: quinta-feira, 13 de Junho de 2002 14:41 Para: [EMAIL PROTECTED] Assunto: Re: [PHP-DB] how is it possible to read data from an excel workbook ? Why use PHP to do this, there are plenty of tools to in Access to import from Excel. Unless there are other considerations, use Access to pull that data. (Hint: Link the excel spreadsheet and run an (update or append) query. Jeremy At 02:34 PM 6/13/2002 +0100, you wrote: >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