Below is the response I got from SAS Tech Support: This may be caused by a registry key not being present or not registered. Here is how you deal with this normally. Usage Note 11012: Error: Trying to establish connection and ISAM errors when importing and exporting PC File Formats When you attempt to import or export PC File Formats such as Microsoft Excel or Microsoft Access files, the following error messages might appear: Error trying to establish connection. Could not find installable ISAM. The error message can appear even when the latest Microsoft Data Access Components (MDAC) have been installed. They appear because the registry entries listed in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines are not pointing to the correct locations. The most common problem is with the Msexcl40.dll where it is pointing to C:\Windows rather than C:\winnt or vice versa. Other dlls being pointed to incorrectly include msexch40.dll, msrd2x40.dll, msrd3x40.dll, msltus40.dll, mspbde40.dll, mstext40.dll, and msxbde40.dll. For more information, consult Microsoft Knowledge Base articles 283881 and 209805 at http://www.microsoft.com. This can also be caused by the MSEXCL40.DLL not being registered. You can check it as follows: 1.Make sure that Msexcl40.dll exists in the system or system32 folder. 2.Open regedit. Make sure that the correct path to Msexcl40.dll is located at: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel 3.If both conditions exist, re-register the DLL using regsrv32.exe: “regsrv32 c:\winnt\system32\Msexcl40.dll” (From Start>Run or command prompt. You may need to find the location of regsrv32 before running.) If 1 or 2 are false, you will need to install (or re-install) Office (or at the very least Excel).
... View more
