BookmarkSubscribeRSS Feed

It seems proc import can retrieve data from Excel if the data is in a sheet by itself using the "sheet=" statement, known range i.e., "A1:C10", or named range using the "range=" statement.  What I don't see is an easy way to import the data if it is an Excel Table.  Something like a "table=" statement in the code below to accomplish this would be extremely helpful.  I apologize if this already exists, I couldn't find anything.  Thanks in advance for your attention to this matter.

 

proc import out= WANT
	datafile= "C:\ExcelFile.xlsm"
	dbms= EXCEL replace;
	TABLE= "TBL";
run;