The problem that Excel cannot import SAS with parameters

[jiashenke]

SAS Server Server Server Server Operating System (Windows 2012)

SASServer software

SASEG Client Operating System (Windows 10)

SASEG software

Office 2013 or Office 2016

Access Database Engine (Excel ODBC Driver)

The following statement can be used to import Excel files into SAS, which is completely imported without parameters.

libname DDTWB XLSX "\\192.168.10.211\SASDocs\Test\HTST00003\Docs\SP\SDTM\HPR SP-001-T04-I Data Mapping Tool_HTST00003.xlsx" ;

Figure 1

The following statement can be used to import Excel file into SAS, then show Class not Registered, which calls Access Database Engine, the driver of Excel ODBC.

libname DDTWB EXECL“\\192.168.10.211\SASDocs\Test\HTST00003\Docs\SP\SDTM\HPR SP-001-T04-I Data Mapping Tool_HTST00003.xlsx" mixed=yes dbmax_text=23767 header=no;

Figure 2

[Kurt_Bremser]

Please copy/paste both logs as they are into windows opened with the {i} button. The contents of your pdf do not correlate (completely) with what you posted.

[jiashenke]

Thank you very much！I'll collect it and send it to you later.

[SASKiwi]

Your class not registered error is most likely due to 64-SAS trying to communicate with 32-bit MS Office. This can be solved by downloading the MS Office 64-bit JET engine from the Microsoft website.

Why do you need to use the EXCEL engine when the XLSX engine successfully assigns?

[jiashenke]

Thank you! I'll test it later.