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.
Saturday, December 28, 2019
Excel connect with MYSQL database through ODBC
1. MYSQL ODBC driver download
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.
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.
No comments:
Post a Comment