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.johnson@ubs.com" <matthew-c.johnson@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.johnson@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}}

