Displaying 1 result from an estimated 1 matches for "rcduadmits5".
Did you mean:
cduadmits
2007 Oct 22
0
RODBC problem: sqlSave not working after an update
...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 corr...