Error in imporing excel data to SAS

[Srikanth_J]

Hi,

I'm getting the following error while importing excel(.xlsx) data into SAS.

ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
Connection Failed. See log for details.

Thanks in Advance. 

[RW9]

Can you supply some information.  What SAS product are you using.  What OS its installed on, local or server.  What code your running. Sounds like your using the XLSX engine, but its not installed.

[Srikanth_J]

I'm using SAS 9.4, on Win 10 64 bit

[Amir]

Hi,

It looks like a similar question was solved as follows:

https://communities.sas.com/t5/SAS-Enterprise-Guide/Error-Connect-Class-not-registered/td-p/184367

Other potentially useful links are:

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

http://support.sas.com/kb/52/649.html

http://support.sas.com/kb/43/933.html

All the links were found by doing a web search on the message you posted "error: Connect: Class not registered".

HTH.

Regards,

Amir.

[Srikanth_J]

Thanks @ Amir

[Amir]

@Srikanth_J, No problem.

If you're just thanking me for my response then thank you too.

If you're thanking me because it is the solution then it is best practice to also mark the answer as the solution to assist others, just like the first link I sent was a help in this case.

Regards,

Amir.