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: cannot allocate vector of
size 27.9 Mb
In addition: Warning messages:
1: In names(value) <-
make.unique(colnames) :
Reached total allocation
of 1535Mb: see help(memory.size)
..
Then I tried to increase the memory size and import the
data again
>memory.limit(size=2000)
However I still got the same error message like
below
Error: cannot allocate vector of
size 27.9 Mb
Can someone please help me solve this problem? Thanks so
much in advance.
Cindy
[[alternative HTML version deleted]]
______________________________________________
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.
