Re: [R] import a dataset from Access database into R

2011-12-06 Thread jim holtman
Yo need to provide a lot more information. For example, how large is the dataset you are trying to read (how many row/columns). I assume that you are running under Windows probably with a 32-bit version of R, but who knows. How big are the rest of the objects that you have in your global environ

[R] import a dataset from Access database into R

2011-12-06 Thread Ying Zhou
Hi I was trying to import a dataset from access database into R My code looks like below >library(RODBC) >setwd("//STATESFPSOP1/docs/CRMPO/DEPT/Retail PD") >channel<-odbcConnectAccess("MortgagePD.mdb") >Mdata<-sqlFetch(channel, "MortgagePD") But I got error messages saying Error: canno