I'm trying to import data held in Excel files which have different file extensions: .xls. .xlt, .xlsx, .xlsm. Is there a single way to import these files? There is a large number of them so I'd prefer not to have to change/update the file type first. The files are read from a Windows 7 network to a SAS EG Unix server using proc import dbms excelcs. Any help appreciated!
... View more