R help - Nov 2009 - Problem with sqlSave

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. It
appends in the existing worksheets but doesn? t delete the existing datas.
Any idea?



-----
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-tp26421303p26421303.html
Sent from the R help mailing list archive at Nabble.com.

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