-->
The Microsoft Open Database Connectivity (ODBC) interface is a C programming language interface that makes it possible for applications to access data from a variety of database management systems (DBMSs). ODBC is a low-level, high-performance interface that is designed specifically for relational data stores.
The ODBC interface allows maximum interoperability-an application can access data in diverse DBMSs through a single interface. Moreover, that application will be independent of any DBMS from which it accesses data. Users of the application can add software components called drivers, which interface between an application and a specific DBMS.
The instructions below apply to Excel 2016, 2019 and Office 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. Microsoft ODBC Driver 11 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 2005, 2008, 2008 R2, SQL Server 2012, SQL Server 2014 and Windows Azure SQL Database. Apr 16, 2018 On the Start menu, click Run. In the Open text box, type regedit and then click OK; this starts Registry Editor. In the Navigation pane, drill-down to the following path: HKEYLOCALMACHINESoftwareMicrosoftDataAccess. In the Details pane, look in the Name column for FullInstallVer and Version.
Documentation
Documentation of ODBC interfaces and methods.
- Microsoft-Supplied ODBC Drivers.; 2 minutes to read; In this article. Drivers are libraries that implement the functions in the ODBC API. Each driver is specific to a particular database management system (DBMS).
- Query Tool (using ADO) 7.0 x64 Edition 7.0.4.56 - Query OLE DB data sources, author SQL scripts and queries. Top4Download.com offers free. software downloads for Windows, Mac, iOS and Android computers and mobile devices. Visit for free, full and secured software’s.
The Microsoft ODBC Data Source Administrator manages database drivers and data sources.
Documentation for the ODBC Desktop Database Drivers, the ODBC Driver for Oracle, and the Visual FoxPro速 ODBC Driver.
Microsoft ODBC Test is an ODBC-enabled application that you can use to test ODBC drivers.
Defines terms relevant to ODBC.
Describes the command-line utility for configuring drivers and data source names.
Support
Mac Odbc Manager
Information about support options can be found on the Microsoft Help and Support Web site.