RE: [PHP] Excel sheet operations with PHP
| From: | Balaji Ankem | Date: | Wed, 23 Oct 2002 11:18:49 +0000 |
| Subject: | RE: [PHP] Excel sheet operations with PHP | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-121061@lists.php.net to get a copy of this message | ||
Is the below mentinoned software available now?
-----Original Message-----
From: Maxim Maletsky [mailto:maxim@php.net]
Sent: Wednesday, October 23, 2002 4:12 PM
To: Justin French
Cc: Balaji Ankem; php-general@lists.php.net
Subject: Re: [PHP] Excel sheet operations with PHP
There is some very good software made by a brazillian guy that doies it
very automatically - it converts CSV files, excel and access into mySQL.
Not sure of the name. Anyone?
---
Maxim Maletsky
maxim@php.net
www.PHPBeginner.com // PHP for Beginners
www.maxim.cx // my Home
// my Wish List: ( Get me something! )
http://www.amazon.com/exec/obidos/registry/2IXE7SMI5EDI3
Justin French <justin@indent.com.au> wrote... :
> I save excel sheets as CSV (Windows, not Mac), then use functions like
> fget_csv() to read the CSV file one line at a time, inserting into
> MySQL with standard insert queries.
>
> Have a go, and let me know if you need more help. I'm pretty sure
> there are decent samples of everything except the mysql stuff in the
> manual... I'll make the assumption you know how to insert :)
>
>
> Justin
>
>
>
> on 23/10/02 8:19 PM, Balaji Ankem (balaji.ankem@wipro.com) wrote:
>
> > Hi Friend,
> > How to read from Excel file and to insert in to the database? Do we
> > have any option to import excel sheet to Mysql database through php?
> > Or any other mechanism?
> >
> > Any inputs will be greatly appreciable.
> >
> > Thanks and Regards
> > Balaji
> >
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
**************************Disclaimer************************************************ Information contained in this E-MAIL being proprietary to Wipro Limited is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. ***************************************************************************************
**************************Disclaimer************************************************ Information contained in this E-MAIL being proprietary to Wipro Limited is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. ***************************************************************************************