VBA data query to MySQL Database in Excel Mac 2016

Looking for a VBA code to connect to a MySQL Database and run a SQL query to retrieve data in Excel Mac 2016. Please advice on ODBC/MySQL driver for OSX. Thank you.