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.
- Odbc Driver For Microsoft Access
- What Is Microsoft Sql Server
- Openlink Odbc Driver For Microsoft Sql Server For Mac
The instructions below apply to Excel 2016, 2019 and Office 365 fo Mac.
Odbc Driver For Microsoft Access
Jul 10, 2018 Microsoft ODBC Driver 17 for SQL Server is a single dynamic-link library (DLL) containing run-time support for applications using native-code APIs to connect to Microsoft SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, Analytics Platform System, Azure SQL Database and Azure SQL Data Warehouse. OpenLink Lite ODBC Driver for SQL Server TDS 7.0 - High-Performance ODBC Drivers. Download the latest versions of the best Mac apps at safe and trusted MacUpdate Download, install, or update OpenLink Lite ODBC Driver for SQL Server TDS for Mac from MacUpdate. ODBC Driver 13.1 for SQL Server adds support for Always Encrypted and Azure Active Directory when used in conjunction with Microsoft SQL Server 2016. New distributions supported: OS X 10.11 and macOS 10.12 are supported in the first release of the ODBC Driver on macOS. Actual ODBC Driver for SQL Server & Sybase. Use this driver to connect to your company's Microsoft SQL Server or Sybase databases. This driver installs completely on your Mac - nothing is installed on the server itself. Unicode enabled 32/64-bit ODBC Driver for Mac. Connect to any SQL Server compatible database from popular Mac applications like FileMaker Pro and Office 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:
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.
From OpenLink Software:High-Performance ODBC Drivers provide transparent access to remote databases from any ODBC-compliant application. Desktop Productivity Tools (i.e., Spreadsheets, Word Processors, Presentation Packages, Desktop Databases, Personal Organizers, etc.), Client-Server Application Development Environments, Web-based Database Publishing Tools, and Computer Telephony Integration packages, are just a few of the many products that can take advantage of our standards compliance.
This driver works in combination with the OpenLink Multi-Tier ODBC Server components -- Request Broker and Database Agents -- typically installed on a remote host. Database Agents are available for direct connections to DB2, Informix, Ingres, Microsoft SQL Server, MySQL, OpenLink Virtuoso, Oracle, PostgreSQL, Progress, Sybase ASA, Sybase ASE, as well as bridged connections to any Agent-local JDBC or ODBC driver or data source.
What Is Microsoft Sql Server
- Blistering Performance
- ODBC v1.0 through v3.5 Compliance
- ODBC Core, Level 1, Level 2, and Extensions support
- Client-based Scrollable Cursor Support