Import an excel file with a sheets

[LineMoon]

I want to import many sheets in excel file as sas datas

And I want the data name=sheet name

[SASKiwi]

My favoured approach is to use the EXCEL LIBNAME (you need SAS/ACCESS to PC Files for this):

libname inxls excel "MyWorkbook.xls";

proc datasets library = out;

  copy in = inxls out = out;

run;

quit;

[LineMoon]

When I use

proc setinit; run;

I see : SAS/ACCESS to PC Files

But it does not work, why ?

when I write

libname inxls excel "MyWorkbook.xls";

I have an error

[SASKiwi]

When asking why an error has occurred please also supply your error message otherwise I would be guessing what the problem is.

[LineMoon]

I will send you the error message later

But , if  i remember well, it will write

ERROR .....EXCEL.....

Question: we do not need a  window server with SAS/ACCESS to PC Files ?