Hi Karl, I was setting append=true because safer would delete the former datas when set to false. I must not have understood the purpose of these two attributes right. To be honest I tried all possible combinations and none would work. I am doing all this now with RExcel as I have been advised and it worked very well. Thank you for trying to help.
Karl Ove Hufthammer wrote: > > On Thu, 19 Nov 2009 04:07:52 -0800 (PST) anna_l <lippelanna21 > @hotmail.com> wrote: >> Hello, the sqlSave function is used in order to write a dataframe on >> excel. >> This function creates worksheets using the attribute tablename and writes >> the data.frame in it. What I want to do is to create this data.frame but >> being able in case this worksheet already exists to delete the former >> datas >> and write the new ones in it. I used the safer and append attributes. >> When >> you set safer to false, from what I understood, it should delete the >> former >> datas. Then what I did is setting safer as false and append as true so it >> can append to the empty dataframe the new dataframe but it didn?t work. > > Your question doesn't make sense. If you want to delete the older data, > you should *not* use append = TRUE, since that is used only in the case > that you want to append the new data to the old date. Since you *don't* > want to retain the old data, why do you set append = TRUE? > > -- > Karl Ove Hufthammer > > ______________________________________________ > 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. > > ----- Anna Lippel new in R so be careful I should be asking a loooooooot of questions!:teeth: -- View this message in context: http://old.nabble.com/Problem-with-sqlSave-tp26421303p26441564.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ 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.