[R] export date field using sqlSave

Al Kirschbaum aakirsch at gmail.com
Wed Sep 19 18:29:10 CEST 2012


Hello-

I'm receiving an error when I try to export a dataframe into Access
2010 containing a date field using sqlSave. The error I'm receiving
is:

[RODBC] Failed exec in Update
22018 39 [Microsoft][ODBC Microsoft Access Driver]Invalid character
value for cast specification

I can export all other columns, except the date column. If I convert
the date column to julian (numeric) it works fine, but if I keep it as
POSIXct, POSIXt, or date, it will return the same error.

I'm using RODBC version 1.3-6.

Thank you

-al



More information about the R-help mailing list