[Rd] RODBC sqlSave not all columns

waanders waanders at gmail.com
Thu Jul 29 16:41:34 CEST 2010


How can I make sqlSave only to write a subset of columns.

I've a (MS-Access) table with columns A, B, C en D and if I send a sqlSave
command with a data frame with columns A, B en D I get the message:

Error in odbcUpdate(channel, query, mydata, coldata[m, ], test = test,  : 
  missing columns in 'data'
Calls: sqlSave -> sqlwrite -> odbcUpdate

(The columns in my table are all defined optional)

I can add a dummy column to my data frame with name C and value NA and
sqlSave will be happy, but is there another way to do this? Arguments to
sqlSave? I can't find them in the documentation.

View this message in context: http://r.789695.n4.nabble.com/RODBC-sqlSave-not-all-columns-tp2306570p2306570.html
Sent from the R devel mailing list archive at Nabble.com.

More information about the R-devel mailing list