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. 















1 comment:

digitalhts said...

Thank you for sharing a valuable comment and its very relevant concept. Otherwise if anyone want to learn SAP contact us on -+ 9599119376 Or Visit Website- http://www.saptrainingdelhi.com/