Usage Note 5506: Importing from Excel 97 or 2000 where the sheet name contains an &
fails.
Importing an Excel 97 or 2000 workbook where the sheet name contains an
&
results in the following WARNING and ERROR messages:
WARNING: Apparent symbolic reference * not resolved.
ERROR: Import unsuccessful. See SAS Log for details.
Where * is the alphanumeric after the & in the sheet name.
The current work around is to remove the & from the sheet name.
A Technical Support Hot Fix for Release 8.2 TSLEVEL 2M0 for this problem
is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#005506
For customers running SAS with Asian Language Support (DBCS), this Hot
Fix should be downloaded from:
http://www.sas.com/techsup/download/hotfix/82_dbcs_prod_list.html#005506
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft Windows 95/98 | 8.1 TS1M0 | |
| Microsoft Windows 2000 Server | 8.1 TS1M0 | |
| Windows Millennium Edition (Me) | 8.2 TS2M0 | |
| Microsoft Windows 2000 Advanced Server | 8.1 TS1M0 | |
| Microsoft Windows 2000 Datacenter Server | 8.1 TS1M0 | |
| Microsoft Windows 2000 Professional | 8.1 TS1M0 | |
| Microsoft Windows NT Workstation | 8.1 TS1M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Usage Note |
| Priority: | medium |
| Date Modified: | 2002-04-23 14:54:02 |
| Date Created: | 2001-07-26 11:53:02 |
