The following example shows the syntax for specifying the format of
Excel data in PROC IMPORT, as supported by SAS/ACCESS Interface for PC
Files:

  PROC IMPORT OUT= WORK.test5
          DATAFILE= "c:\dbms\excel\V2000\sasdemo.xls"
          DBMS=EXCEL REPLACE;
     Range="Customer_Information";
     GETNAMES=YES;
     FORMAT FIRST_ORDER_Date mmddyy10. NAME $32. ;
  RUN;

Operating System and Release Information