Good day, all. I just upgraded to R 2.6.0. I re-installed my most-used packages including RODBC to be sure I'm up-to-date. I have been working with a large insurance claims dataset stored in a MS-Access database on a Windows machine. I have been regularly exporting tables from R into it using sqlSave. It's worked like a charm until today, when this happened:
> CDUchannel<-odbcDriverConnect() > sqlSave(CDUchannel,CDUAdmits,tablename="RCDUAdmits5") Error in sqlSave(CDUchannel, CDUAdmits, tablename = "RCDUAdmits5") : [RODBC] Failed exec in Update 22018 39 [Microsoft][ODBC Microsoft Access Driver]Invalid character value for cast specification (null) > When I open the database in Access, I find that a table with the correct name has been created, it contains the right number of columns and all are appropriately named, but it is empty. There is a long pause between entering the command and the error message printing, so some processing is happening. I couldn't find anything using "sqlSave","RODBC",and "Access" recently in the archives search. Anybody understand this error message, or why I'm suddenly getting it now? All help appreciated, as always. Thanks, ~Pat. Pat Carroll. what matters most is how well you walk through the fire. bukowski. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ______________________________________________ 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.
