[R] Import from excel 2007

Earl F. Glynn efg at stowers-institute.org
Wed Oct 17 21:30:42 CEST 2007


"Marc Schwartz" <marc_schwartz at comcast.net> wrote in message 
news:1192643111.3525.15.camel at Bellerophon.localdomain...
> 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" <marc_schwartz at comcast.net> wrote in message 
news:1192649145.3525.31.camel at Bellerophon.localdomain...
> 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



More information about the R-help mailing list