Using PROC IMPORT with a DBMS=Excel to read an Excel file that was
created using Lotus Notes XML code, the following error can occur:

     PROC IMPORT OUT= registration
      DATAFILE="c:\myfile.xls"
      DBMS=EXCEL2000 REPLACE;
      sheet="SheetName";
      GETNAMES=YES ;
      MIXED=YES;
      SCANTEXT=YES;
      USEDATE=YES;
      SCANTIME=YES;
    RUN;

  ERROR: Connect: External table is not in the expected format.
  ERROR: Error in the LIBNAME statement.
  Connection Failed.  See log for details.
  NOTE: The SAS System stopped processing this step because of errors.

Even though the Excel filename has the .xls extension, it is an XML
file, which PROC IMPORT does not recognize.

Users can open the file in Excel and use the File - Save As menu to save
the file as a Microsoft Excel Workbook *.xls and then use PROC IMPORT to
read the new file into SAS.

Operating System and Release Information