Join us on Wednesday, June 3rd for a deep dive into Customer Predictive Analytics Learn more

Connect to MS Access file with Date/Time data type

Level 2
Connect to MS Access file with Date/Time data type

Hi,

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

  • Error type:net.ucanaccess.jdbc.UcanaccessSQLException

 Thank you for any suggestion,

Best regards,

Romana

 

0 Kudos
0 Replies