RE: RE: [PHP-DB] how is it possible to read data from an excel workbook ?

[Jose Moreira]

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

Re: [PHP-DB] how is it possible to read data from an excel workbook ?

[Srinivasan Ramakrishnan]

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