Import XLSB file using SAS 9.4 64 bit

[maxjiang6999]

PROC IMPORT DATAFILE= "C:\Users\x\Proj\Data\A Information Resource.xlsb"  
OUT= WORK.ALLTRACTS
DBMS=Excel REPLACE; 
/*GETNAMES=YES;*/
SHEET = "1)LICs";
RUN;  

Hi there, 

I'm trying to import an XLSB file using SAS 9.4. My code is posted above but the system gave the error:

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

Can anyone help?

Thanks!

[Shmuel]

This question was already solved in this forum:

https://communities.sas.com/t5/SAS-Enterprise-Guide/Import-xlsb-SAS-EG-7-1-64-bits/td-p/351501 

[SASKiwi]

Yes, looks like you have the 32-bit Excel to 64-bit SAS problem. The 64-bit ACE engine, a free download from Microsoft, is the solution. Note this only works if your SAS is running on Windows, which it looks like it is.