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" <[EMAIL PROTECTED]>
To: "Kunal Jhunjhunwala" <[EMAIL PROTECTED]>
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
>
>
>


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to