copying from mysql to Excel

C

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?
 
H

Harlan Grove

cndesigner said:
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?
Click to expand...

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
 
Top