Will not import EXCEL proc import problems since OFFICE 2016 upgrade (EXCEL).

BJH_MICH — Wed, 22 Aug 2018 22:21:06 GMT

Have a PROC IMPORT that was running fine until I updated to OFFICE 2016 (from OFFICE 2010)...

I have confirmed that BOTH SAS (9.3) and my OFFICE 2016 are BOTH 32 - bit.

proc import file=specs out=formats dbms=excel replace;

range='formats';

getnames=yes;

scantext=yes;

run;

Now I am getting this error....Googling this problem people mention it occurs when you have different "bit" for SAS versus OFFICE...but both mine are 32 - bit...

Any other ideas?

ERROR: Connect: Class not registered

ERROR: Error in the LIBNAME statement.

Re: Will not import EXCEL proc import problems since OFFICE 2016 upgrade (EXCEL).

Reeza — Wed, 22 Aug 2018 22:27:02 GMT

Weird. Nothing else changed?

It's possible a driver was accidentally deleted somehow.

proc setinit;run;*what is licensed;

proc product_status;run; *what is installed;

@BJH_MICH wrote:

Have a PROC IMPORT that was running fine until I updated to OFFICE 2016 (from OFFICE 2010)...

I have confirmed that BOTH SAS (9.3) and my OFFICE 2016 are BOTH 32 - bit.

proc import file=specs out=formats dbms=excel replace;

range='formats';

getnames=yes;

scantext=yes;

run;

Now I am getting this error....Googling this problem people mention it occurs when you have different "bit" for SAS versus OFFICE...but both mine are 32 - bit...

Any other ideas?

ERROR: Connect: Class not registered

ERROR: Error in the LIBNAME statement.

topic Will not import EXCEL proc import problems since OFFICE 2016 upgrade (EXCEL). in SAS Programming

Will not import EXCEL proc import problems since OFFICE 2016 upgrade (EXCEL).

Re: Will not import EXCEL proc import problems since OFFICE 2016 upgrade (EXCEL).