Hello, 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. Regards. -- 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. ______________________________________________ R-devel@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-devel
