Usage Note 37412: Errors occur when you import Microsoft Excel or Microsoft Access files into SAS® 9.2
When you import Excel or Access files to or export them from SAS 9.2 (TS2M0) or later, you can receive the following errors:
Error: Connect: Class not registered
Error: Error in the Libname statement
These errors can occur even when you can successfully import these files to or export them from SAS 9.1 on the same machine. The problem also occurs often when you do not Microsoft Office 2007 installed.
The problem results from the fact that SAS 9.2 uses the Microsoft Access Connectivity Engine (ACE) to create Excel and Access files. If you do not have this engine installed, the Class not registered error occurs because the Windows registry is missing the Access Connectivity Engine registry key.
You can check for the registry key in Windows 32 environments by following these steps:
- Select Start ► Run. Then type regedit in the Open list box to display the Registry Editor.
- In the registry tree, select HKEY_LOCAL_MACHINE ► Software ► Microsoft ► Office ► 12.0 ► Access Connectivity Engine ;
If you are running 32-bit SAS on a Windows X64 system you will find it in this location.
- In Windows environments, select Start ► Run. Then type regedit in the Open list box to display the Registry Editor.
- In the registry tree, select HKEY_LOCAL_MACHINE ► Software ► Wow6432Node ► Microsoft ► Office ► 12.0 ►.
- Verify that the Access Connectivity Engine registry key is in the list.
If the ACE is not in the registry, you should install the Microsoft's Data Connectivity Components. You can change the display language dependent on the language of the machine.
Microsoft Office 2007 is not required in order to install these components. You can also use these components to install the latest Microsoft ODBC and OLEDB drivers.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.21 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.21 | | 9.2 TS2M0 | |
| Microsoft Windows XP 64-bit Edition | 9.21 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.21 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.21 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Standard Edition | 9.21 | | 9.2 TS2M0 | |
| Microsoft Windows XP Professional | 9.21 | | 9.2 TS2M0 | |
| Windows Vista | 9.21 | | 9.2 TS2M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
The following errors can occur when you import Excel or Access files into SAS 9.2 or later: "Error: Connect: Class not registered" and "Error: Error in the Libname statement".
| Type: | Usage Note |
| Priority: | |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> MS Access
Data Management ==> Data Sources ==> External Databases ==> MS Excel
|
| Date Modified: | 2010-03-02 11:22:21 |
| Date Created: | 2009-10-09 12:32:20 |
