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