Re: [R] create an access file

2013-04-15 Thread Jeff Newmiller
You missed that this is not the RStudio support forum. You probably also missed that R comes in both 32-bit and 64-bit flavors in the Windows binary distribution, and you have to use the one that matches the ODBC drivers you want to use. You can specify which version RStudio is to use. -

Re: [R] create an access file

2013-04-15 Thread Aileen Lin
Hi there, I tried the command in https://stat.ethz.ch/**pipermail/r-help/2007-June/** 133606.html In R, it works OK. In Rstudio, there seems to be a problem: library(RODBC)ch <- odbcDriverConnect("Driver={Microsoft Access Driver (*.md

Re: [R] create an access file

2013-04-15 Thread Aileen Lin
worked it out. Thank you. misunderstood the post earlier. Aileen On 15 April 2013 20:17, Prof Brian Ripley wrote: > On 15/04/2013 07:12, Aileen Lin wrote: > >> Hi there, >> >> I have seen this post. >> https://stat.ethz.ch/**pipermail/r-help/2007-June/**133606.html

Re: [R] create an access file

2013-04-15 Thread Prof Brian Ripley
On 15/04/2013 07:12, Aileen Lin wrote: Hi there, I have seen this post. https://stat.ethz.ch/pipermail/r-help/2007-June/133606.html have odbc installed in my machine. Now I have the following message: channel2 <- odbcDriverConnect("test.mdb")Warning messages:1: In odbcDriverConnect("test.mdb"

[R] create an access file

2013-04-15 Thread Aileen Lin
Hi there, I have seen this post. https://stat.ethz.ch/pipermail/r-help/2007-June/133606.html have odbc installed in my machine. Now I have the following message: channel2 <- odbcDriverConnect("test.mdb")Warning messages:1: In odbcDriverConnect("test.mdb") : [RODBC] ERROR: state IM002, code 0,