Fetch data from mysql into Excel

1.    Download

https://dev.mysql.com/downloads/connector/odbc/

2.    Install

Double click the downloaded file and install

3.    Configure:

Control Panel > Administrative Tools > Data Sources (ODBC) [double click]

From Divers Tab verify that ‘MYSQL ODBC 5.3 ANSI Driver is installed.

4.    Reference to ADODB

While in Excel, Go to VBA Editor, Tools>References

5.    Check ‘Microsoft ActiveX Data Objects 2.0 Library’ 

6. Place the following code in VBE (press ALT + F11) in your excel workbook.

Make sure the MYSQL server is running. Edit the server url, user and pass. run the macro. Enjoy.