Let us see if it is a R issue. Try this: Read the CSV on Ms Access directly. It is an importation on MsAccess.
If you succeed we will check R then. Caveman On Sun, May 16, 2010 at 11:48 AM, Johan Lassen <johanlas...@gmail.com> wrote: > 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. > > ______________________________________________ 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.
