How To Connect To Mysql From Excel 2016 For Mac

1. How To Connect To Mysql From Linux

Excel 2016 has issues (much more substantial in October 2015, but still present in November 2016). It's really not ready for prime time. Excel 2011 is a better bet, as things stand.

How To Connect To Mysql From Linux

There is a good answer here: How do I connect MS Excel to MySQL database in Mac? But it talks about Excel 2011 and an old MacOS. Is there a way to sync a Google Sheet and Microsoft Excel 2016? Does Google have access to my Google sheet? Ask New Question.

If you're stuck with Excel 2016, update to the latest (3.52.12, as of July 2016), create your DSN (System DSN recommended; User DSN may work for you) in iODBC Administrator.app (found in /Applications/iODBC/), and then use it with Excel. (, produced by, is the open source ODBC driver manager Apple has bundled into OS X since 10.2, but Apple remains several years behind the current iODBC version.).