List:General Discussion« Previous MessageNext Message »
From:Jason Trebilcock Date:January 6 2010 3:40am
Subject:RE: Exporting the result of a Query into excel
View as plain text  
> -----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
> 
> 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
 

Thread
Exporting the result of a Query into excelishaq gbola5 Jan
  • Re: Exporting the result of a Query into excelJay Ess5 Jan
    • Re: Exporting the result of a Query into excelishaq gbola5 Jan
      • Re: Exporting the result of a Query into excelJay Ess5 Jan
        • Re: Exporting the result of a Query into excelishaq gbola5 Jan
          • Re: Exporting the result of a Query into excelsureshkumarilu5 Jan
      • Re: Exporting the result of a Query into excelsureshkumarilu5 Jan
      • Re: Exporting the result of a Query into excelJim Lyons5 Jan
        • Re: Exporting the result of a Query into excelCarsten Pedersen5 Jan
          • Re: Exporting the result of a Query into excelLawrence Sorrillo5 Jan
          • Re: Exporting the result of a Query into excelJim Lyons5 Jan
  • Re: Exporting the result of a Query into excelJim Lyons5 Jan
  • RE: Exporting the result of a Query into excelJason Trebilcock6 Jan
Re: Exporting the result of a Query into excelishaq gbola5 Jan
  • Re: Exporting the result of a Query into excelsureshkumarilu5 Jan
  • Re: Exporting the result of a Query into excelMichael Dykman5 Jan