How to fetch data from MySQL database into Excel

Question

How to fetch data from MySQL database table into Excel?

Answer 1

1. Install Connector/ODBC

2. Create an ODBC DSN (Control Panel / Administration / ODBC if on Windows)

3. Import data using Microsoft Query (Data / External Data / From Other Sources / Microsoft Query in Excel 2007)

Answer 2

If your server is also your client machine you can do

select * from table1 into outfile 'c:/path/outfile.csv'

(Note the use of forward slashes even on Windows)

If your server is a remote machine, make sure your have the MySQL client software installed on the client machine and do:

mysql -e "SELECT * from table1" > file_name

You can then open the csv file in Excel.