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 in order 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 in order for it to be read into SAS with the
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 under investigation.
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: | 2008-07-22 15:34:35 |
| Date Created: | 2007-03-19 10:32:47 |
