Usage Note 40547: "Unrecognized database format" error when trying to import Microsft Access 2007 .ACCDB file
Using either PROC IMPORT code or the Import Wizard to read Microsoft Access 2007 .ACCDB data into SAS 9.2 TS1M0 might return the following error:
ERROR: Connect: Unrecognized database format 'c:\my documents\mydatabase.accdb'.
ERROR: Error in the LIBNAME statement.
ERROR: Connect: Cannot start your application. The workgroup information
file is missing or opened exclusively by another user.
ERROR: Error in the LIBNAME statement.
ERROR: Connect: Unrecognized database format 'c:\my documents\mydatabase.accdb'.
ERROR: Error in the LIBNAME statement.
NOTE: Attachments for -3 reestablished for new parent.
NOTE: Import Cancelled.
In order to access Microsoft Excel 2007 and Microsoft Access 2007 data, customers must use at least the second maintenance release for SAS 9.2 (TS2M2).
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.21 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.21 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.21 | | 9.2 TS2M0 | |
| Microsoft Windows XP 64-bit Edition | 9.21 | | 9.2 TS2M0 | |
| Microsoft® Windows® for x64 | 9.21 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.21 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.21 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Standard Edition | 9.21 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 for x64 | 9.21 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2008 for x64 | 9.21 | | 9.2 TS2M0 | |
| Microsoft Windows XP Professional | 9.21 | | 9.2 TS2M0 | |
| Windows Vista | 9.21 | | 9.2 TS2M0 | |
| Windows Vista for x64 | 9.21 | | 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.
| Date Modified: | 2010-12-20 17:36:23 |
| Date Created: | 2010-08-09 15:20:43 |
