Problem Note 32219: Read-access violations and initialization errors occur when you use the EXCEL engine to import workbooks that were created by the XLS engine
When you use the EXCEL engine to import workbooks that were created by the XLS engine in the UNIX environment, you can receive the following errors:
Error: Connect: Unable to IDBInitialize
Error: Error in the LIBNAME statement
Error: Read Access Violation in Task [IMPORT]
Exception occurred at (7C911DC8)
When this happens, your SAS® session might not respond.
If the Excel workbook is created by the XLS engine on a Windows 32-bit system, you will receive the following error:
ERROR: Connect: External table is not in the expected format.
ERROR: Error in the LIBNAME statement.
The problem occurs because in SAS® 9.2 you can create multiple worksheets in an Excel workbook using the XLS engine, as shown:
proc export outfile='multisheet1.xls' dbms=xls
data=sashelp.class replace;
sheet='class';
run;
proc export outfile='multisheet1.xls' dbms=xls data=sashelp.air replace;
sheet='air';
run;
When the XLS engine creates these multiple worksheets in a workbook, it groups them. (The tabs are highlighted white, indicating that they are grouped). This grouping prevents the EXCEL engine from importing the Excel file properly. To circumvent the problem, take one of the following actions:
- The workbook method:
- Open the Excel workbook.
- Click the second tab to ungroup it. As an alternative, you can just use CTRL+left-click, which ungroups the first tab.
- Then save the Excel file and import it with the EXCEL engine.
- The XLS method: Simply import the file using the XLS engine (DBMS=XLS) rather than the EXCEL engine (DBMS=EXCEL).
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to PC Files | Solaris for x64 | 9.2 TS1M0 | 9.2 TS2M2 |
| Linux for x64 | 9.2 TS1M0 | 9.2 TS2M2 |
| Linux | 9.2 TS1M0 | 9.2 TS2M2 |
| HP-UX IPF | 9.2 TS1M0 | 9.2 TS2M2 |
| 64-bit Enabled Solaris | 9.2 TS1M0 | 9.2 TS2M2 |
| 64-bit Enabled HP-UX | 9.2 TS1M0 | 9.2 TS2M2 |
| 64-bit Enabled AIX | 9.2 TS1M0 | 9.2 TS2M2 |
| Windows Vista | 9.2 TS1M0 | 9.2 TS2M2 |
| Microsoft Windows XP Professional | 9.2 TS1M0 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS1M0 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS1M0 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS1M0 | 9.2 TS2M2 |
| Microsoft® Windows® for x64 | 9.2 TS1M0 | 9.2 TS2M2 |
| Microsoft Windows XP 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M2 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS1M0 | 9.2 TS2M2 |
*
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.
Errors can occur when you use the EXCEL engine to import workbooks that were created by the XLS engine in the UNIX environment.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2008-09-11 11:14:37 |
| Date Created: | 2008-05-23 10:48:04 |
