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]