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]]


