I recently updated my computer to Windows 10, and have Microsoft Office 64-bit and SAS 64-bit (9.04.01). I have no problem running an existing proc import statement with Excel, but my existing import code with Access is no longer working. If I try to run this: proc import out=codebook datatable="Matrix Table" dbms=ACCESS REPLACE; database = "C:\Users\keh\Documents\Matrix.accdb"; run; I receive the error: ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement. ERROR: Connection Failed. See log for details. This error typically occurs because of a mismatch between SAS and Office "bits", 64 vs. 32, and the solution is usually to obtain the PC Files Server. However, if the 'bits' are the same you aren't supposed to need the PC Files Server. (Since I am able to import Excel files, that would suggest the problem is not a general incompatibility with Office.) Another possibility in this situation is that you should download Access Runtime in Microsoft. I tried this, but got an error when trying to install it that the version of Office I have installed doesn't work with Runtime, and that I should delete and reinstall Office in the Click-to-Run version if I want to download Runtime. If there is a simpler solution I would prefer not to uninstall and reinstall a different version of Office. Does anyone have insights? Thank you!
... View more