Re: Excel sheet operations with PHP
| From: | Maxim Maletsky | Date: | Wed, 23 Oct 2002 11:32:37 +0000 |
| Subject: | Re: Excel sheet operations with PHP | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-121063@lists.php.net to get a copy of this message | ||
Yes.
I am just not sure what it's name was.
.. thinking deeper, it might have been called DBTools.
YUP! here it is:
www.dbtools.com.br
See if it does what you need.
---
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
"Balaji Ankem" <balaji.ankem@wipro.com> wrote... :
>
> 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
>