"Marc Schwartz" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > This might be a question along the lines of "is it plugged in?", but do > you have the Office 2007 version of the ODBC drivers installed? > > If not, then your results would not be a surprise. > > If you do, then we should get Prof. Ripley involved here, as we did have > a brief offlist communication on this yesterday, thinking that RODBC > "should" work if the proper version of the ODBC drivers are installed. ...
"Marc Schwartz" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I would guess that the same would be the case for odbcConnectAccess(). > > In the other case, using odbcDriverConnect(), you are explicitly naming > the driver, so it works. > > So for the time being, using odbcDriverConnect() would be the approach > to use. I was still exploring this when your newer post appeared. I installed everything from the Microsoft Office 2007 Professional DVD back in March. I assumed all the ODBC drivers were installed but don't really know. In Control Panel | Administrative Tools | Data Sources (ODBC) Under drivers: Driver do Microsoft Excel (*.xls) 6.00.6000.16386 Microsoft Corporation ODBCJT32.dll 11/2/2006 Microsoft Excel Driver (*.xls) 6.00.6000.16386 Microsoft Corporation ODBCJT32.dll 11/2/2006 Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb) 6.00.6000..16386 Microsoft Corporation ACEODBC.DLL 10/26/2006 Microsoft Excel-Treiber (*.xls) 12.00.4518.1014 Microsoft Corporation ACEODBC.DLL 10/26/2006 I'll try the odbcDriverConnect and let you know. efg ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.