Usage Note 60321: Using the EXCEL or ACCESS engine triggers "Error: Connect: Class not registered..." with Microsoft Office 2016 or Microsoft Office 365
 |  |  |  |
The following error might be generated when using a SAS/ACCESS® Interface to PC Files engines such as EXCEL or ACCESS:
ERROR: Error in the LIBNAME statement.
This error is a result of a missing Microsoft driver package that is required for successfully working with these file types.
To circumvent this problem, it is recommended that you install Microsoft Access 2013 Runtime. To download the software, go to the Microsoft Access website. Note that the download should have the same bitness as the currently installed Microsoft Office on the system. The 32-bit download is labeled AccessRuntime_x86_en-us.exe, whereas the 64-bit download is named AccessRuntime_x64_en-us.exe.
If this error persists after you install the driver package, there is most likely a mismatch in the bitness between SAS® and Microsoft Office. To confirm and workaround this problem, refer to SAS KB0036453: "Steps to troubleshoot 'ERROR: Connect: Class not registered' in SAS/ACCESS® Interface to PC Files engines."
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft® Windows® for 64-Bit Itanium-based Systems | ||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | ||||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | ||||
| Microsoft Windows XP 64-bit Edition | ||||
| Microsoft® Windows® for x64 | ||||
| Microsoft Windows 8 Enterprise x64 | ||||
| Microsoft Windows 8 Pro x64 | ||||
| Microsoft Windows 8.1 Enterprise x64 | ||||
| Microsoft Windows 8.1 Pro x64 | ||||
| Microsoft Windows 10 | ||||
| Microsoft Windows Server 2003 for x64 | ||||
| Microsoft Windows Server 2008 for x64 | ||||
| Windows 7 Enterprise x64 | ||||
| Windows 7 Home Premium x64 | ||||
| Windows 7 Professional x64 | ||||
| Windows 7 Ultimate x64 | ||||
| Windows Vista for x64 | ||||
| Type: | Usage Note |
| Priority: |
| Date Modified: | 2017-05-15 11:25:00 |
| Date Created: | 2017-04-19 14:08:54 |