[R] any way to append a table in SQL server

Jim Porzak jporzak at gmail.com
Wed Mar 21 17:53:45 CET 2007


see...
> library(RODBC)
> ?sqlSave

and rest of RODBC docs. You could also pass a SQL INSERT statement
through sqlQuery()

On 3/20/07, Wensui Liu <liuwensui at gmail.com> wrote:
> Dear Lister,
> Is there an interface in R with SQL server that allows me to append
> records to table in the DB? Might I do that using RODBC?
> Thanks a lot.
>
> --
> WenSui Liu
> A lousy statistician who happens to know a little programming
> (http://spaces.msn.com/statcompute/blog)
>
> ______________________________________________
> R-help at stat.math.ethz.ch 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.
>


-- 
HTH/Best,
Jim Porzak
Loyalty Matrix Inc.
San Francisco, CA
http://www.linkedin.com/in/jimporzak



More information about the R-help mailing list