Re: [R] RODBC connect to Excel (64-bit Windows 7)

2012-05-25 Thread Gabor Grothendieck
On Sun, Dec 4, 2011 at 9:40 AM, andrija djurovic wrote: > Hi to all. >  I have a problem to connect to an Excel database using RODBC. There are tips for RODBC as well as some alternatives listed here: http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows -- Statistics & Software Consult

Re: [R] RODBC connect to Excel (64-bit Windows 7)

2012-05-25 Thread Paul Bivand
If you're using (R)ODBC, you need a workflow that is either 32bit or 64-bit, but not mixed. On a 64-bit Windows 7 machine, I can use 32-bit R and RODBC to read and write 32-bit Excel (etc) and similarly xlsreadwrite works 32-bit. I can use 64-bit R and XLConnect to read and write from excel sprea

Re: [R] RODBC connect to Excel (64-bit Windows 7)

2012-05-23 Thread IzRey
andrija djurovic gmail.com> writes: > > Hi to all. > >.. > > Thanks in advance > > Andrija I am having the exact same problem. Any luck with this yet? __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do r

Re: [R] RODBC connect to Excel (64-bit Windows 7)

2011-12-04 Thread andrija djurovic
Hi. Not specifically, but I used it before with 32-bit R under Windows XP and it worked just fine so i though to keep using it.Anyway I will lookt at XLConnect. Thank you for suggestion. Andrija On Sun, Dec 4, 2011 at 7:41 PM, R. Michael Weylandt < michael.weyla...@gmail.com> wrote: > Do you nee

Re: [R] RODBC connect to Excel (64-bit Windows 7)

2011-12-04 Thread R. Michael Weylandt
Do you need to use RODBC specifically? I've been using XLConnect quite a lot recently and have been quite pleased with it. Michael On Dec 4, 2011, at 9:40 AM, andrija djurovic wrote: > Hi to all. > I have a problem to connect to an Excel database using RODBC. > Namely, I am using 64-bit R 2.1

[R] RODBC connect to Excel (64-bit Windows 7)

2011-12-04 Thread andrija djurovic
Hi to all. I have a problem to connect to an Excel database using RODBC. Namely, I am using 64-bit R 2.14.0, under Windows 7 and I tried following: library(RODBC) > channel <- odbcConnectExcel("results.xlsx") Error in odbcConnectExcel("results.xlsx") : odbcConnectExcel is only usable with 32-bit