Usage Note 38535: An error occurs when you import Microsoft .XLSB and .XLSX files into SAS® 9.2
When you import Microsoft Excel .XLSB and .XLSX files into SAS, you can receive the following error message:
ERROR: Connect: This file was created in a previous beta
version of Excel 2007. Open the file with Excel 2007 to
save it to the most recent version of the Excel
2007 file format before opening the file in Access 2007.
The problem can occur after you apply Microsoft patch MS09-067 to your system. For details about the patch, see
"Microsoft Security Bulletin MS09-067 - Important".
<
The problem occurs because the .XLSB files are created with an older release of Microsoft Office 2007, which contains vulnerabilities. The patch fixes those vulnerabilities, but it does not enable the older files to be imported by the Microsoft Access Connectivity Engine, which SAS uses. To resolve the problem, resave the files in an updated copy of Microsoft Office.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M0 | |
| Microsoft Windows XP 64-bit Edition | 9.2 TS2M0 | |
| Microsoft Windows XP Professional | 9.2 TS2M0 | |
| Windows Vista | 9.2 TS2M0 | |
*
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.
After you apply Microsoft Security patch MS09067, you can receive an error when you import .XLSB and .XLSX files. To solve the problem, you must save your files in an updated copy of Microsoft Excel.
| Type: | Usage Note |
| Priority: | |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> MS Access
Data Management ==> Data Sources ==> External Databases ==> MS Excel
|
| Date Modified: | 2010-10-27 09:40:59 |
| Date Created: | 2010-01-28 16:06:42 |
