Error while connecting to MS Access data

Hi,
I need to bring MS Access data into my Knime workflow. I used Microsoft Access Connector node but got this error message:
“Execute failed: UCAExc:::4.0.4 Decoding not supported. Please choose a CodecProvider which supports reading the current database encoding.”
Any advice would be appreciated
Thanks,
Denis

Hi @dvarshav ,

Welcome to KNIME Community.

There were couple of similar errors in the past and I have pasted some of them below, Let us if the provided information helped you to resolve your issue.

Regards,
Nagarjun S

1 Like

Thank you, I appreciate the quick response.
I ended up importing MS Access db into SQL server and then using SQL connector node in Knime.
Thanks,
Denis Varshavsky

1 Like