Problem Note 49033: The connection to Excel fails when you use the LIBNAME engine with INIT= and UDL= options
An error is returned when you use a LIBNAME statement to Excel that specifies the INIT= or UDL= option, as follows:
libname db excel init=
'Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=c:\temp\mixedtypes.xlsx;Mode=Read;Extended Properties="Excel 12.0
Xml;IMEX=1;"';
libname db excel init=
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX;
ERROR: Connect: Only MS Jet Provider are allowed
ERROR: Error in the LIBNAME statement.
libname db excel udl="C:\Documents and Settings\<userid>\My Documents\My Data Sources\excel.udl";
libname db excel udl=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX;
ERROR: Connect: Only MS Jet Provider are allowed
ERROR: Error in the LIBNAME statement.
A fix for this issue is planned for a future software release.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft® Windows® for x64 | 9.3_M1 | 9.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.3_M1 | 9.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.3_M1 | 9.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 9.3_M1 | 9.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 |
| Microsoft Windows Server 2003 for x64 | 9.3_M1 | 9.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 |
| Microsoft Windows Server 2008 | 9.3_M1 | 9.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 |
| Microsoft Windows Server 2008 for x64 | 9.3_M1 | 9.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 |
| Microsoft Windows XP Professional | 9.3_M1 | 9.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 |
| Windows 7 Enterprise 32 bit | 9.3_M1 | 9.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 |
| Windows 7 Enterprise x64 | 9.3_M1 | 9.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 |
| Windows 7 Home Premium 32 bit | 9.3_M1 | 9.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 |
| Windows 7 Home Premium x64 | 9.3_M1 | 9.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 |
| Windows 7 Professional 32 bit | 9.3_M1 | 9.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 |
| Windows 7 Professional x64 | 9.3_M1 | 9.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 |
| Windows 7 Ultimate 32 bit | 9.3_M1 | 9.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 |
| Windows 7 Ultimate x64 | 9.3_M1 | 9.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 |
| Windows Vista | 9.3_M1 | 9.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 |
| Windows Vista for x64 | 9.3_M1 | 9.3_M1 | 9.3 TS1M2 | 9.4 TS1M0 |
*
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: | Problem Note |
| Priority: | high |
| Date Modified: | 2013-02-04 11:24:45 |
| Date Created: | 2013-01-30 15:23:49 |
