When importing complex Excel spreadsheets with the IMPORT procedure using DBMS=XLS, the following error might occur:

PROC IMPORT OUT= WORK.LOTSCELLS2
      DATAFILE= "C:\ExcelFiles\2006_notes_spec.xls"
      DBMS=xls REPLACE;
      SHEET="Notes";
RUN;

Memory request error
ERROR: Not enough memory available to allocate storage.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.13 seconds
      cpu time            0.01 seconds

When using DBMS=EXCEL, the import is successful.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at: