Retrieving data. Wait a few seconds and try to cut or copy again.

Modified on Fri, 27 Feb at 4:08 AM

When Attempting to use MSQuery in MS Office for Mac, the connection cannot be established because there are no connectivity options to the database.

Explanation

Using MSQuery in a Mac environment might be difficult as there are requirements to use ODBC (to connect through to the database) and Mac OS does not have native ODBC drivers. In Office 2016 for Mac, there is the option to directly connect to a SQL database but there is no guarantee that this will work correctly. There are also third-party options that may facilitate the necessary database connection, but these can be expensive.

Helpful Links

This Article may be helpful for Office 2016: https://blogs.office.com/2015/08/20/working-with-external-data-in-excel-2016-for-mac/
This article explains the data connection required: https://support.office.com/en-us/article/Import-data-from-a-database-e127365a-02a5-47b5-8278-16dd65edbe61
Third-party ODBC drivers for Mac environments: https://support.office.com/en-us/article/ODBC-drivers-that-are-compatible-with-Excel-for-Mac-9fa6bc7f-d19e-4f7f-9be4-92e85c77d712?ui=en-US&rs=en-US&ad=US

This information is provided as a courtesy, MS Query is a third-party application and is not supported by Synergetic support. If you have any issues connecting your database to MS Office on your Mac device, please speak with Microsoft Support or seek support from the vendor of your third-party ODBC driver.