Problem Note 68222: You might see the error "Missing Microsoft Office Component" when you try to import an Access or Excel file into SAS® Enterprise Guide®
 |  |  |  |  |
You might see the error below if you import a Microsoft Access file into SAS Enterprise Guide:
---------------------------
Missing Microsoft Office Component
---------------------------
The selected file appears to be a Microsoft Access 2007 or later file.
Missing Microsoft Office Component
---------------------------
The selected file appears to be a Microsoft Access 2007 or later file.
You also might see the following error if you import a Microsoft Excel file into SAS Enterprise Guide:
---------------------------
Missing Microsoft Office Component
---------------------------
The selected file appears to be a Microsoft Excel 2007 or later binary file.
Missing Microsoft Office Component
---------------------------
The selected file appears to be a Microsoft Excel 2007 or later binary file.
These messages appear when Office 365 is installed on your system, even when both versions of SAS Enterprise Guide and Office 365 are the same bitness.
This issue occurs because SAS Enterprise Guide looks for specific Microsoft product keys in the Windows registry to see whether the MS ACE drivers are installed. However, Office 365 no longer uses those same product keys.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Enterprise Guide | Microsoft Windows Server 2012 R2 Std | 8.2 | 8.3 | 9.4 TS1M7 | |
| Microsoft Windows Server 2012 R2 Datacenter | 8.2 | 8.3 | 9.4 TS1M7 | |||
| Microsoft Windows Server 2008 for x64 | 8.2 | 8.3 | 9.4 TS1M7 | |||
| Microsoft Windows Server 2008 R2 | 8.2 | 8.3 | 9.4 TS1M7 | |||
| Microsoft Windows 10 | 8.2 | 8.3 | 9.4 TS1M7 | |||
| Microsoft® Windows® for x64 | 8.2 | 8.3 | 9.4 TS1M7 | |||
| Microsoft Windows 8 Enterprise 32-bit | 8.2 | 8.3 | 9.4 TS1M7 | |||
| Microsoft Windows 8 Enterprise x64 | 8.2 | 8.3 | 9.4 TS1M7 | |||
| Microsoft Windows 8 Pro 32-bit | 8.2 | 8.3 | 9.4 TS1M7 | |||
| Microsoft Windows 8 Pro x64 | 8.2 | 8.3 | 9.4 TS1M7 | |||
| Microsoft Windows 8.1 Enterprise 32-bit | 8.2 | 8.3 | 9.4 TS1M7 | |||
| Microsoft Windows 8.1 Enterprise x64 | 8.2 | 8.3 | 9.4 TS1M7 | |||
| Microsoft Windows 8.1 Pro 32-bit | 8.2 | 8.3 | 9.4 TS1M7 | |||
| Microsoft Windows 8.1 Pro x64 | 8.2 | 8.3 | 9.4 TS1M7 | |||
| Microsoft Windows Server 2016 | 8.2 | 8.3 | 9.4 TS1M7 | |||
| Microsoft Windows Server 2019 | 8.2 | 8.3 | 9.4 TS1M7 | |||
A fix for this issue for SAS Enterprise Guide 8.3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I8T.html#68222| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2021-08-13 13:01:32 |
| Date Created: | 2021-08-06 13:25:22 |