Displaying 1 result from an estimated 1 matches for "position_ftsehx".
2009 Aug 18
1
Specify Database location from R
...39;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]]