Dear R-community,

After repeating the sqlSave-command 3 times on a dataframe (of size 13149
rows * 5 columns) to my MS-Access database I get the following error:

*Error in sqlSave(channel, eksport_transp_acc_2, "transp_acc_scenarier",  :
unable to append to table ‘transp_acc_scenarier’*
**
This means that the first 2 savings are completed, but the third-one
is somehow not. I have an idea that perhaps it is due to some out-of-memory
problem. My PC has 2 CPUs, 1.83 G Hz, 0.99 GB RAM.

Have anyone got some idea of what causes and solves the problem? I have
tried also with the function "*gc()*", but without success.

Thanks in advance,
Best regards,
Johan



PS:
I use the following code, where the file *eksport_transp_acc_2_rbind.csv* is
of size 13149*5:


*library(RODBC)*
**
*eksport_transp_acc_2 <-
read.table(file = "results/csv/eksport_transp_acc_2_rbind.csv",
 sep =";", header = T)*
**
*sqlSave(channel,eksport_transp_acc_2,
"transp_acc_scenarier",append = T,fast = F,rownames = F)
*





-- 
Johan Lassen

"In the cities people live in time -
in the mountains people live in space"

	[[alternative HTML version deleted]]

