http://mysqlblog.fivefarmers.com/2012/11/08/using-mysql-for-excel/
http://stackoverflow.com/questions/13558921/how-can-vba-connect-to-mysql-database-in-excel
http://office.microsoft.com/en-us/excel-help/connect-to-a-mysql-database-HA104019820.aspx
Connect to a MySQL database
Before you can connect to a MySQL database, you need the MySQL Connector on your computer. To install the MySQL Connector (Connector/Net), go to http://go.microsoft.com/fwlink/?LinkId=278885 and downloadConnector/Net 6.6.5 for Microsoft Windows. The driver bit-ness needs to match the Microsoft Power Query for Excel add-in installation (32-bit or 64-bit).
- In the POWER QUERY ribbon tab, click From Database > From MySQL Database.
- In the MySQL Database dialog box, in Server Name specify the MySQL Database Server to connect to.
- Click OK.
- If the MySQL server requires database user credentials:
- In the Access a Database dialog box, enter your username and password.
- Click Save.