05-31-2018 07:50 AM
I got my system upgraded to windows 10 and sas upgraded to 9.4 and EG 7.1
I have got all the necessary plugins installed but when I try to run the below query it thorws the below error. xls or xlsx are not getting imported via query, but when I inport them from EG settings (file--> import file) it is getting imported:
Proc import datafile="c:\Users\ID\test\Sample.xlsx"
ERROR: DBMS type XLSX is not valid for import
same error occured when used excel or excelcs. Please advise
05-31-2018 09:00 AM