[Rd] RODBC sqlSave not all columns

From: waanders <waanders_at_gmail.com>
Date: Thu, 29 Jul 2010 07:41:34 -0700 (PDT)


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.

R-devel_at_r-project.org mailing list
Received on Fri 30 Jul 2010 - 00:14:01 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Fri 30 Jul 2010 - 09:40:21 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-devel. Please read the posting guide before posting to the list.

list of date sections of archive