Displaying 1 result from an estimated 1 matches for "test_rodbc".
2012 May 29
1
RODBC, Excel, and data truncation when writing
...elements
that exceed 255 bytes, which appears to be the cell width limit in Excel.
Below is example code and the warning message received:
library(RODBC)
d <- data.frame(v1=c(1,2),v2=c(paste(rep("test",100),collapse=""),"test"))
z <- odbcConnectExcel2007("test_rodbc.xlsx",readOnly=FALSE)
sqlSave(z,d,tablename="Sheet1",rownames=FALSE)
odbcClose(z)
Warning message:
In odbcUpdate(channel, query, mydata, coldata[m, ], test = test, :
character data
'testtesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttestte...