Try your hand at analyzing royal sentiment in Dataiku DSS! 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

 

2 Replies
Level 2

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/

Best regards,
Richard

Community Manager
Community Manager

A new Knowledge Base article has been published on this topic: Utilizing MS Access in Dataiku DSS

Don't forget to mark as "Accepted Solution" when someone provides the correct answer to your question.
0 Kudos