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
