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