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:10}}
______________________________________________ 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.
