Ok I´ve been trying to understand what is happening: the data.frame I am sending on the xls file has been constructed by the following way: I used the RODBC package to read dates and prices columns into a dataframe so the first column in excel is of type "date". In the data.frame it is not numeric but still double. So when I change the xls files I read by turning these dates datas into numbers, everything works well. So I don´t know if something has to be changed within the data.frame containing the dates or if I have to do everything in numbers and use RDCOM after to change the date column format of the excel file back into date type.
anna_l wrote: > > Thanks Karl, well I am getting an error now after the following sqlSave > command: > sqlSave( xlsFile, datas, tablename = 'Datas_and_coefficients', rownames = > FALSE ) > > --> [RODBC] Failed exec in Update > 22018 39 [Microsoft][Driver ODBC for Excel]invalid character value for the > diffusion specification (null) (null) > > > More specifically, take a look at the 'append' and 'safer' arguments. > > -- > 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/Writing-a-data-frame-in-an-excel-file-tp26378240p26416861.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.