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

2007-03-21 Thread Jim Porzak
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 [EMAIL PROTECTED] 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@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

__
R-help@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.


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

2007-03-20 Thread Wensui Liu
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@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.