[R] Help with SQLsave

Ramesh YAPALPARVI ramesh.yapalparvi at icloud.com
Thu Jan 25 00:00:39 CET 2018


Hi all,



I'm using RODBC library to connect to a database.

I'm trying to read a table from a database and after manipulating it would like to write to the same database but with a different table



P<-data.frame(sqlQuery(myconn,'select  *  from Demographics'))
sqlSave(myconn,p,tablename="trial",rownames=FALSE)




I'm gettng this error







Version:1.0 StartHTML:0000000107 EndHTML:0000001014 StartFragment:0000000127 EndFragment:0000000996
Error in sqlSave(myconn, p, tablename = "trial", rownames = FALSE) : 
  [RODBC] Failed exec in Update
22018 0 [Microsoft][ODBC Driver 11 for SQL Server]Invalid character value for cast specification


Thanks,

Ramesh


More information about the R-help mailing list