When you use the SAS PC Files Server or you use a LIBNAME statement with the EXCELCS or PCFILES engine to import a Microsoft Excel file, you might receive the following message:

ERROR: CLI error trying to establish connection: 
[Microsoft][ODBC Excel Driver] General error Unable to open registry key 
Temporary (volatile) Ace DSN for process 0x490 Thread 0xbbc DBC 0x3bb7fdc Excel'. 
ERROR: Error in the LIBNAME statement.

This problem occurs for several reasons, including not having permissions on an ODBC registry key. In such a case, change the permissions on the registry key as follows:

1. Start the registry editor using the regedit command: select Start ► Run and enter regedit.
2. If your SAS PC Files Server is on a 64-bit machine, expand the following key: HKEY_LOCAL_MACHINE ► SOFTWARE ► WOW6432NODE ► ODBC.

   If your SAS PC Files Server is on a 32-bit machine, expand the following key: HKEY_LOCAL_MACHINE ► SOFTWARE ► ODBC.

3. Right-click the ODBC folder and select Permissions.
4. Make sure that the logon ID that is running the SAS process has full control.

The problem might also occur due to older ODBC drivers from Microsoft, particularly from Office 2007. To install the newer ODBC drivers, go to Microsoft Access Database Engine 2010 Redistributable. If you have 32-bit Microsoft Office, download the AccessDatabaseEngine.exe file. Download the other ODBC driver only if you have 64-bit version of Microsoft Office.

The problem can also occur when an Excel workbook has sheets that contain links to data that are no longer available. To test for this, copy the data from the existing Excel workbook to a new Excel workbook. Then attempt to import the new workbook data.

Operating System and Release Information