Another way to do this is to get the data as HTML then just open the file in Excel.
The mysql client has a switch for HTML output. Just redirect the output of your query to a file. Try the following: mysql -h < query.sql > /path/result.sql Best Regards, Boyd E. Hemphill MySQL Certified Professional [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2287 M: (713) 252-4688 -----Original Message----- From: Andrew Pattison [mailto:[EMAIL PROTECTED] Sent: Friday, August 20, 2004 8:01 AM To: [EMAIL PROTECTED] Subject: Re: excel Two main ways: 1. Dump your tables to a file and import them using the text import filter. 2. Install MyODBC and open a connection to the MySQL tables in Excel. Since Excel is a proprietary file format, MySQL does not support it. Also, bear in mind that Excel has a 65,535 row limit hard coded into it - which means if you want column headings you are limited to 65,534 rows. Cheers Andrew. ----- Original Message ----- From: "Scott Hamm" <[EMAIL PROTECTED]> To: "'Mysql ' (E-mail)" <[EMAIL PROTECTED]> Sent: Friday, August 20, 2004 2:53 PM Subject: excel > How do I export from mysql into excel format? > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
