For more information, see Import data from a database in Excel for Mac 2011. Drivers that are compatible with Excel for Mac 2011 are available from these companies:Īfter you install the driver for your source, you can use Microsoft Query to create new queries or refresh existing queries that were created in other versions of Excel, such as Excel X, Excel 2004, and Excel for Windows. This version of Excel does not provide an ODBC driver. The driver you get depends on which version of Excel for Mac you have. If you want to import data into Excel for Mac from a database, you need an Open Database Connectivity (ODBC) driver installed on your Mac. Quoted from the MSKB in case the link dies
ODBC drivers that are compatible with Excel for Mac With (Connection:=connstring, Destination:=Range('A1'), Sql:=sqlstring)Īre there add-ins available? Even from a third-party? The following code creates a connection to a mySQL database, and returns information from the database into Cell A1: Dim connstring as StringĬonnstring = 'ODBC DRIVER= ' _ Download and install their program and you'll have the necessary drivers for connecting to SQL servers and databases (Free to try, $35 to purchase). ADODB is NOT supported in Mac Excel 2011, but ODBC works in conjunction with a 3rd party driver.
