From: Jason Trebilcock
Date: January 6 2010 3:40am
Subject: RE: Exporting the result of a Query into excel
List-Archive: http://lists.mysql.com/mysql/220092
Message-Id: <4b44063c.5744f10a.3de5.ffffa578@mx.google.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="utf-8"
Content-Transfer-Encoding: quoted-printable


> -----Original Message-----
> From: ishaq gbola [mailto:ishaqgbo@stripped]
> Sent: Tuesday, January 05, 2010 7:18 AM
> To: mysql@stripped
> Subject: Exporting the result of a Query into excel
>=20
> Hi all,
>=20
> 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
>=20
>=20

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
=20