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/.
It finally works now! However I have encountered issues when trying to connect to bigger databases (over 500MB). Dataiku seems to crush every time I try to connect to such a big DB. Do you have any tip / workaround for that?
Many thanks for you help!