Problem Note 43801: Microsoft Excel data is not properly imported and an error is generated when you import .xls or .xlsx files in which font changes are used
When you import an Excel .xls or .xlsx file in which font changes are used, data might be omitted. The font changes might introduce false spaces in column names, which can make the column names too long. When this problem occurs, an error similar to the following is generated:
ERROR: An exception has been encountered.
Please contact technical support and provide them with the following traceback
information:
The SAS task name is [IMPORT]
ERROR: Read Access Violation IMPORT
Exception occurred at (0650F0E4)
Task Traceback
Address Frame (DBGHELP API Version 4.0 rev 5)
000000000650F0E4 0000000009F865C0 sasimxlx:tkvercn1+0xE0A4
000000000650C1C3 0000000009F9E4A0 sasimxlx:tkvercn1+0xB183
0000000006508458 0000000009F9E660 sasimxlx:tkvercn1+0x7418
0000000006501893 0000000009F9E6A0 sasimxlx:tkvercn1+0x853
0000000007882E41 0000000009F9E6A8 sasimctr:tkvercn1+0x1E01
00000000078817C4 0000000009F9F770 sasimctr:tkvercn1+0x784
0000000006321277 0000000009F9F778 sasimpor:tkvercn1+0x237
0000000002F88B07 0000000009F9FCB8 sashost:Main+0xF437
0000000002F8D13D 0000000009F9FF50 sashost:Main+0x13A6D
00000000778DF56D 0000000009F9FF58 kernel32:BaseThreadInitThunk+0xD
0000000077B13021 0000000009F9FF88 ntdll:RtlUserThreadStart+0x21
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.61 seconds
cpu time 0.10 seconds
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.21_M2 | 9.3_M1 | 9.2 TS2M3 | 9.3 TS1M1 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.21_M2 | 9.3_M1 | 9.2 TS2M3 | 9.3 TS1M1 |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.21_M2 | 9.3_M1 | 9.2 TS2M3 | 9.3 TS1M1 |
| Microsoft Windows XP 64-bit Edition | 9.21_M2 | 9.3_M1 | 9.2 TS2M3 | 9.3 TS1M1 |
| Microsoft® Windows® for x64 | 9.21_M2 | 9.3_M1 | 9.2 TS2M3 | 9.3 TS1M1 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.21_M2 | 9.3_M1 | 9.2 TS2M3 | 9.3 TS1M1 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.21_M2 | 9.3_M1 | 9.2 TS2M3 | 9.3 TS1M1 |
| Microsoft Windows Server 2003 Standard Edition | 9.21_M2 | 9.3_M1 | 9.2 TS2M3 | 9.3 TS1M1 |
| Microsoft Windows Server 2003 for x64 | 9.21_M2 | 9.3_M1 | 9.2 TS2M3 | 9.3 TS1M1 |
| Microsoft Windows Server 2008 | 9.21_M2 | 9.3_M1 | 9.2 TS2M3 | 9.3 TS1M1 |
| Microsoft Windows Server 2008 for x64 | 9.21_M2 | 9.3_M1 | 9.2 TS2M3 | 9.3 TS1M1 |
| Microsoft Windows XP Professional | 9.21_M2 | 9.3_M1 | 9.2 TS2M3 | 9.3 TS1M1 |
| Windows 7 Enterprise 32 bit | 9.21_M2 | 9.3_M1 | 9.2 TS2M3 | 9.3 TS1M1 |
| Windows 7 Enterprise x64 | 9.21_M2 | 9.3_M1 | 9.2 TS2M3 | 9.3 TS1M1 |
| Windows 7 Home Premium 32 bit | 9.21_M2 | 9.3_M1 | 9.2 TS2M3 | 9.3 TS1M1 |
| Windows 7 Home Premium x64 | 9.21_M2 | 9.3_M1 | 9.2 TS2M3 | 9.3 TS1M1 |
| Windows 7 Professional 32 bit | 9.21_M2 | 9.3_M1 | 9.2 TS2M3 | 9.3 TS1M1 |
| Windows 7 Professional x64 | 9.21_M2 | 9.3_M1 | 9.2 TS2M3 | 9.3 TS1M1 |
| Windows 7 Ultimate 32 bit | 9.21_M2 | 9.3_M1 | 9.2 TS2M3 | 9.3 TS1M1 |
| Windows 7 Ultimate x64 | 9.21_M2 | 9.3_M1 | 9.2 TS2M3 | 9.3 TS1M1 |
| Windows Vista | 9.21_M2 | 9.3_M1 | 9.2 TS2M3 | 9.3 TS1M1 |
| Windows Vista for x64 | 9.21_M2 | 9.3_M1 | 9.2 TS2M3 | 9.3 TS1M1 |
*
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: | Problem Note |
| Priority: | medium |
| Date Modified: | 2011-10-17 13:30:35 |
| Date Created: | 2011-07-21 15:59:17 |
