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 <johanlassen at 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 at 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.
>
>