hey PG so i copied your syntax but then when i try to ACCESS the file through this library i get errors libname db OLEDB INIT_STRING="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\xx\Desktop\yyy.xls;Extended Properties='Excel 8.0;HDR=Yes;IMEX=0';Persist Security Info=True"; proc print data=db.yyy;run; ERROR: Invalid data set name db.daily.report_jan2_8. ERROR: File WORK.DAILY.DATA does not exist. ps.so i think the " db.yyy" was wrong and i did try to access any of the sheets in this excel file db.'sheet1$'n and it did not work again Error: ERROR: Describe error: IColumnsInfo::GetColumnInfo failed. : The Microsoft Access database engine could not find the object 'sheet1$'. Make sure the object exists and that you spell its name and the path name correctly. If 'sheet1$' is not a local object, check your network connection or contact the server administrator. What i am doing wrong now ?
... View more