Re: exporting
| From: | Kunal Jhunjhunwala | Date: | Mon, 19 Nov 2001 22:14:29 +0000 |
| Subject: | Re: exporting | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-75156@lists.php.net to get a copy of this message | ||
I need something that will do a direct transfer to word or excel or the
others.. not something via a cvs method..
Regards,
Kunal Jhunjhunwala
----- Original Message -----
From: "Joshua Hoover" <joshuahoover@revivalhealth.com>
To: "Kunal Jhunjhunwala" <kunal@getmonked.net>
Sent: Tuesday, November 20, 2001 3:39 AM
Subject: Re: [PHP] exporting
> You can use something like this from MySQL:
>
> SELECT * INTO OUTFILE 'data.txt'
> FIELDS TERMINATED BY ','
> FROM ...;
>
> This will give you a comma delimited file that you can then import into
> Excel, Access, etc.
>
> You can find more out on this at:
> http://www.mysql.com/doc/L/O/LOAD_DATA.html
>
> Hope that helps.
>
> Joshua Hoover
>
> > hey guys..
> >
> > does anyone have any ideas on how to export information from a mysql
> > database to microsoft word, excel, access, note pad or any other such
> > application?
> >
> >
> > Regards,
> > Kunal Jhunjhunwala
>
>
>