RODBC失败: "invalid character value for cast specification" - Excel 2007

Question

我正在尝试使用RODBC写入Excel2007文件，并且不断出错。我已将问题简化为这种非常基本的情况，即具有字符，数字，日期和逻辑数据类型的1行data.frame:

toWrite = data.frame( Name = "joe" , Date = as.Date("2011-01-01"), Value = 2 , Paid = FALSE )
xlFile = odbcConnectExcel2007( "REPLACE_WITH_XLSB_FILE_PATH" , readOnly = FALSE )
sqlSave( xlFile , toWrite , tablename = "worksheet1" , rownames = FALSE )

错误:

Error in sqlSave(xlFile, toWrite, tablename = "worksheet1", rownames = FALSE) : 
  [RODBC] Failed exec in Update
22018 39 [Microsoft][ODBC Excel Driver]Invalid character value for cast specification 
In addition: Warning message:
In odbcUpdate(channel, query, mydata, coldata[m, ], test = test,  :
  character data 'FALSE' truncated to 1 bytes in column 'Paid'

如果我将日期和逻辑列都转换为字符，则一切正常。问题在于，这些字符现在已成为Excel中的字符，未经转换就不能用作预期的数据类型。我研究了sqlSave代码，它似乎在做正确的事情。还有其他人遇到过这个问题吗？

Answer 1

对于在此问题上遇到麻烦的人(5年后)，可以在R中像varTypes这样在sqlSave()中使用sqlSave(..., varTypes = c(somecolname="datetime", anothercolname= "datetime",...))参数。