Re: [R] Help with SQLsave

2018-01-25 Thread SHUXIANG 'ALBERT' LI
"P" is not "p" try sqlSave(myconn,P,tablename="trial",rownames=FALSE) Have a wonderful day! - Albert From: R-help on behalf of Ramesh YAPALPARVI Sent: Wednesday, January 24, 2018 4:00:39 PM To: R-help@r-project.org Subject:

[R] Help with SQLsave

2018-01-24 Thread Ramesh YAPALPARVI
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="tria