ERROR: DBMS type EXCEL not valid for import.

[sss2]

I am working on SAS studio and trying to import excel file.Apart from excel, I have also tried to convert the file to csv and xml format, but none of them worked.

Everytime I try to import the file, the error occurs.

proc import out = sales
Datafile = "C:\SASUniversityEdition\myfolders\Sales.xml"
DBMS = xml replace;
run;

[mohamed_zaki]

Check this 

How to Import an Excel File to SAS University Edition

Follow the steps mentioned and if you still having problems post again.

[Reeza]

You say Excel but your file reference appears to be XML. 

Is it an Excel file or an XML. The process for importing the two are different.