RE: [PHP] PHP+MySQL -> Excel ?
| From: | savaidis | Date: | Sat, 18 May 2002 08:50:30 +0000 |
| Subject: | RE: [PHP] PHP+MySQL -> Excel ? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-98238@lists.php.net to get a copy of this message | ||
I use the ODBC connection with no problem, I get about 1000 rows to Excel in
seconds.
First row contains the colums names.
But I wonder if there is a way to write back the data to MySQL database from
Excel.
(with ODBC connection, becouse with files I think is possible)
Makis
> -----Original Message-----
> From: Rasmus Lerdorf [mailto:rasmus@php.net]
> Sent: Friday, May 17, 2002 7:54 PM
> To: Chris Boget
> Cc: php-general@lists.php.net
> Subject: Re: [PHP] PHP+MySQL -> Excel ?
>
>
> No, this has nothing to do with PHP. You can run MySQL on Windows or
> UNIX, doesn't matter, and set up a connection directly from Excel to
> MySQL.
>
> PHP can of course run anywhere you want and manipulate the data in MySQL
> which will then be reflected in Excel.
>
> -Rasmus
>
> On Fri, 17 May 2002, Chris Boget wrote:
>
> > > It is also possible to connect directly to MySQL from Excel
> via MyODBC.
> >
> > True, but only if you are running PHP on a windows platform, yes?
> >
> > Chris
> >
> >
> > --
> > 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
>