[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