When you use SAS/ACCESS Interface to ODBC to import Excel files with ranges, you can receive the following error:

The problem occurs even when the worksheet name of the Excel workbook is shorter than 32 characters.

The error occurs because the range, a1:k60 in this case, is also included in the length of the worksheet. The total length of the worksheet and the range must be shorter than 32 characters.

To resolve this problem, you must reduce the number of characters in the worksheet until the name of the worksheet plus the range is less than 32 characters.

Operating System and Release Information