From waanders at gmail.com  Thu Jul 29 16:41:34 2010
From: waanders at gmail.com (waanders)
Date: Thu, 29 Jul 2010 07:41:34 -0700 (PDT)
Subject: [Rd] RODBC sqlSave not all columns
Message-ID: <1280414494400-2306570.post@n4.nabble.com>


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.



[Rd] RODBC sqlSave not all columns
waanders