BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
keh8
Fluorite | Level 6

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! 

 

1 ACCEPTED SOLUTION

Accepted Solutions
keh8
Fluorite | Level 6

The solution to this is to download the driver that is recommended, Microsoft Office *2013* Runtime. I have Office 365 so I figured I'd need the newer version of the driver, but that was incorrect and didn't work. Thanks to SAS Tech Support for helping me with this! 

View solution in original post

4 REPLIES 4
SASKiwi
Opal | Level 21

Did you update MS Office as part of your upgrade? If so to which version? This SAS note may be relevant:

http://support.sas.com/kb/60/321.html

 

BTW, I don't believe SAS 9.4M1 is officially supported on Windows 10. You need to be on 9.4M3 or later if my memory serves me correctly.

keh8
Fluorite | Level 6

Thank you. Yes, the new version is Microsoft Office 365 ProPlus. I tried the 'Runtime' suggestion in that link, but I got an error saying Runtime is incompatible with the version of Office I have. 

SASKiwi
Opal | Level 21

I suggest you track your problem to Tech Support. There may be some issues running on an old maintenance level.

keh8
Fluorite | Level 6

The solution to this is to download the driver that is recommended, Microsoft Office *2013* Runtime. I have Office 365 so I figured I'd need the newer version of the driver, but that was incorrect and didn't work. Thanks to SAS Tech Support for helping me with this! 

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1164 views
  • 2 likes
  • 2 in conversation