> -----Original Message----- > From: ishaq gbola [mailto:ishaq...@yahoo.co.uk] > Sent: Tuesday, January 05, 2010 7:18 AM > To: mysql@lists.mysql.com > Subject: Exporting the result of a Query into excel > > Hi all, > > I would like to know if there is a tool or command in mySQL that allows > one to export the result of query into excel formart > >
If'n you can download and install Toad for MySQL, then the steps might go like this: 1. Write the query 2. Run the query 3. Click the "Export data to an Excel file" button/icon (if you have Excel 2007 installed, it might throw a warning at you) 4. Note where the file was created to. 5. ? 6. Profit! The only caveat to the above is to be aware of how many rows you want to export and the corresponding column/row limitations of whatever version of Excel you have installed. As an additional caveat, you could export to html or csv formats as well which would allow you to work around any size limitations imposed by Excel. Jason -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
