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

______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Reply via email to