Hi MJ, Thanks alot for this. I will try and revert.
 Taby An idea not coupled with action will never get any bigger than the brain cell it occupied. Arnold Glasgow ...... "Attempt something large enough that failure is guaranteedâ¦unless God steps in!" ________________________________ From: "matthew-c.john...@ubs.com" <matthew-c.john...@ubs.com> Cc: r-help@r-project.org Sent: Friday, February 17, 2012 12:48 AM Subject: RE: [R] RODBC sqlSave / append problem (windows XP, R 2.13.2) Hi Taby,  i could not work out how to add to a table, so what i did was to kill the old one and write a new one --  here is a snippet of my code:  # delete the old table sqlDrop(con, sqtable="__mytable__") # note this will hang if the table cannot be found  # insert the new table sqlSave(con,as.data.frame(__myDF__),tablename="__mytable__",rownames=T,fast=T) odbcClose(con) #Close connection to DB  best regards  mj ________________________________ Sent: 16 February 2012 23:29 To: Johnson, Matthew-C Cc: R help Subject: Re: [R] RODBC sqlSave / append problem (windows XP, R 2.13.2) Hi Mj, did you get a solution for this? I am having the same error  Error in odbcUpdate(channel, query, mydata, coldata[m, ], test = test, : missing columns in 'data' I would appreciate if you can share the solution with me. Kind regards, Taby ________________________________ From: mattjo <matthew-c.john...@ubs.com> To: r-help@r-project.org Sent: Monday, December 5, 2011 1:25 AM Subject: [R] RODBC sqlSave / append problem (windows XP, R 2.13.2) Dear All, Using RODBC I have read in a (429 x 11) dataframe from Access, and would like to append two columns of transformed data (429 x 2) to the original table (thereby making it a 429 x 13 table). I would ideally like this to be the same name etc as the original table in Access. I have used the following command: R> sqlSave(con,as.data.frame(SA_data),tablename="Const_mats_8301_t1",rownam es=T,fast=T, append=T) And get the error: Error in odbcUpdate(channel, query, mydata, coldata[m, ], test = test, : missing columns in 'data' Thanks in advance, mj Visit our website at http://www.ubs.com This message contains confidential information and is in...{{dropped:26}} ______________________________________________ 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. Visit our website at http://www.ubs.com This message contains confidential information and is in...{{dropped:25}}
______________________________________________ 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.
