


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]]

