RE: RE: [PHP-DB] how is it possible to read data from an excel workbook ?
| From: | Jose Moreira | Date: | Thu, 13 Jun 2002 14:05:03 +0000 |
| Subject: | RE: RE: [PHP-DB] how is it possible to read data from an excel workbook ? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19786@lists.php.net to get a copy of this message | ||
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:jeremy.peterson@moody.edu]
Enviada: quinta-feira, 13 de Junho de 2002 14:41
Para: jmoreira@e-terno.net
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