Usage Note 19774: SAS® 9.1.3 SP4 for Windows does not support access to Microsoft Office 2007 Excel and Microsoft Access 2007 with cetain SAS/ACCESS® software
SAS 9.1.3 Service Pack 4 for Windows does not support access for file
formats in Microsoft Office 2007 Excel and Microsoft Access 2007 with
SAS/ACCESS® Interface to PC Files software.
You need to save the 2007 Excel file in the Microsoft Excel Workbook
(*.xls) format for it to be read into SAS with the SAS/ACCESS
software mentioned previously.
You also need to convert Microsoft Access 2007 databases to the Access
2002-2003 file format for it to be read into SAS with SAS/ACCESS software.
You can use SAS/ACCESS® Interface to OLE DB or
SAS/ACCESS® Interface to ODBC to access the 2007 versions
of these file formats.
Support for the Office 2007 file format in SAS/ACCESS Interface to PC
Files is available with SAS® 9.2 Phase 2.
For detailed information on reading Excel 2007 files see SAS Note 32455, "The EXCEL and XLS engines do not support the importing and exporting of Microsoft Office 2007 files in SAS® 9.1.3 and SAS® 9.2 Phase 1".
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft Windows NT Workstation | 9.1 TS1M3 SP4 | |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP4 | |
| Microsoft Windows XP Professional | 9.1 TS1M3 SP4 | |
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Server | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Professional | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 SP4 | |
*
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: | 2009-04-09 14:13:41 |
| Date Created: | 2007-03-19 10:32:47 |
