Hello Everyone,
I'm trying to write a table to a specific location in my database from R.
When I use the following code, it is going directly into the first part of
the server which is named 'master' I want to put it onto a different part
of the server called 'HRISK_1'. I think I have to change the tablename
location or specify the location in the databse somehow. Could you please
help me with the syntax of doing this?
Thanks
Conrad
position = read.csv(file = "Position_FTSEhx.csv", header = TRUE)
dataf = data.frame(position)
library(RODBC)
tt = odbcConnect("SOUTHAMPTON", uid = "sa", pwd = "msscapital")
sqlSave(channel = tt, dat = dataf, tablename = "rproject", safer = FALSE)
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org 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.
