Saturday, December 28, 2019

Excel connect with MYSQL database through ODBC

1. MYSQL ODBC driver download

MySQL :: Download Connector/ODBC

WIN 32 or 64 bit

2. From win Start, using "search program and files" to find out ODBC.

3. Add Mysql into User DSN

4. Add ODBC into Excel.

※ Once Mysql table was updated, all push the refresh button, excel sheet will be refreshed at the same time.