In reply to Ethan.

Since Excel docs are binary, I'd say NO -- not without a bunch of other work. But maybe you can use LIBNAME EXCEL or LIBNAME PCFILES or even LIBNAME XLSX to take a pass through the Excel file, pull the field names/types as well as sheet names, and then use that to inform your PROC IMPORT step.