Use Odbc For Excel Mac OS X Has We want to select a text editor on your system and by default Mac OS X has a text editor called TextEdit located in your Applications folder. Select TextEdit in the dialog and select Always Open With to make all.ini files open using this text editor for convenience.

If you want to import data into Excel for Mac from a database (for example, from FileMaker Pro), you need an Open Database Connectivity (ODBC) driver installed on your Mac. The driver you get depends on which version of Excel for Mac you have.

Microsoft Excel for the Mac includes the ability to import live data from a database using an ODBC connection. This tutorial will describe how you can import sales data from an on-line sales database into your Excel spreadsheet. Once the data is in the spreadsheet, you can use Excel to perform further analysis of your sale data. We develop affordable, easy to use ODBC drivers for Mac OS, connecting Excel and FileMaker to Microsoft SQL Server, Oracle, Access, Sybase, MySQL and PostgreSQL. Applications that require or can use ODBC (and therefore the Connector/ODBC driver) include ColdFusion, Filemaker Pro, 4th Dimension and many other applications. On macOS, the ODBC Administrator, based on the iODBC manager, provides easy administration of ODBC drivers and configuration, allowing the updates of the underlying iODBC configuration. ODBC Manager is a Mac OS utility application that configures ODBC data sources for use by popular applications such as Microsoft Excel and FileMaker Pro. Mac OS used to include an ODBC Administrator utilty. Apple stopped including the ODBC Administrator with Mac OS starting with the release of Mac OS X 'Snow Leopard'.

The instructions below apply to Excel 2016, 2019 and Microsoft 365 for Mac.

These versions of Excel do provide an ODBC driver for connecting to SQL Server Databases. On the Data tab, click New Database Query > SQL Server ODBC. Then use the dialog boxes to import the data.

If you are connecting to other ODBC data sources (for example, FileMaker Pro), then you'll need to install the ODBC driver for the data source on your Mac. Drivers that are compatible with Excel for Mac are available from these companies:

Important: As of August 2016, Excel 2016 for the Mac was updated from 32-bit software to 64-bit software. To see if you have this update, click the Excel menu > About Excel. If you have version 15.25 or later, you have the 64-bit version.
The 64-bit update helps Excel run faster, and makes it more reliable when working with very large files. However, if you are using a 32-bit ODBC driver from one of the companies listed above, it may cause Excel to crash when connecting. To avoid this, install a 64-bit driver from the company’s website.

This version of Excel does not provide an ODBC driver. You must install it yourself. Drivers that are compatible with Excel for Mac 2011 are available from these companies:

Odbc Driver For Mac Excel 2011 Free

After 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. For more information, see Import data from a database in Excel for Mac 2011.