Can't use a DSN from an earlier version of Excel for Mac

Symptoms
In Microsoft Excel for Mac for Office 365, ODBC connections for local databases do not work correctly if the data source name (DSN) was created in an earlier version of Excel for Mac. (This issue occurs regardless of the driver. In earlier versions, the database does not have to be in a Sandbox-accessible folder.)

Cause
This issue occurs when the DSN points to a local data source in a location where the ODBC Manager does not have permission to access. This includes your Documents folder.

Workaround
To work around the issue, create a new DSN or connection to the data source. You must also move the data source to a location where the ODBC manager can access it. Here's an example of an accessible folder:

Users/<your user_name>/Library/Containers/com.microsoft.Excel/Data
Note Any subfolder of this directory will also work, as will the /Library folder or a /Library subfolder. By default, the /Library folder and its subfolders are readable to all sandbox applications. 
XL15 AcutalAccess ODBC Apple Driver DNS
מאפיינים:

מזהה פריט: 3075916 - סקירה אחרונה: 07/14/2015 21:53:00 - תיקון: 1.0

Microsoft Excel 2016 for Mac

  • KB3075916
משוב