SAS 9.4 x64 Connect: Class not registered importing excel 2013 x64 file

[PaigeMiller]

Thanks @Vince_SAS , I have forwarded your reply to our IT department.

[MachelleW]

That solution did not work for me.

I still received this error message:

ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
NOTE: Attachments for -3 reestablished for new parent.
NOTE: Import Cancelled.

[SASKiwi]

@MachelleW - Please post your complete SAS log including code and errors. Errors by themselves aren't helpful. Also what OS are you running this on? Windows or Linux? If it is Linux then the only Excel DBMS that will work is XLSX.

[jszabo]

I go through this every year.  Someone else installs office after sas, and the 'Microsoft Access Runtime 2013' gets removed.  Reinstalling the engine fixes it.