I am trying to connect to MS Access files with some fields of Date/Time data type.
I followed the steps suggested in similar post: https://community.dataiku.com/t5/Using-Dataiku-DSS/How-to-open-an-MS-Access-file/m-p/901 but this only works for files without "Date/Time" filed in Access data.
Otherwise I get following error:
UCAExc:::5.0.0 incompatible data type in conversion, caused by: SQLSyntaxErrorException: incompatible data type in conversion, caused by: HsqlException: incompatible data type in conversion
Additional technical details
Thank you for any suggestion,
Seems some bug in either UCanAccess or one of its dependent libraries.
For me it works when using UCanAccess 4.0.4 from https://sourceforge.net/projects/ucanaccess/files/archive/v4_archive/.