copying from mysql to Excel

[cndesigner]

Has anyone, come across this problem.
You have data in mySQL and you want to export it
into an Excel spreadsheet.
How would you go about doing this?

 

[Harlan Grove]

Has anyone, come across this problem.
You have data in mySQL and you want to export it
into an Excel spreadsheet.
How would you go about doing this?

Command line mysql can be used to display query results, and those results
can be redirected to text files. There'd be some additional work involved in
parsing such text files into multiple column Excel workbook ranges, but it's
do-able. Also, you could use MyODBC to query mysql databases directly using
Data > Get External Data.

You could also read the documentation.

http://dev.mysql.com/doc/mysql/en/Reference.html