Error while connecting to MS Access data

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

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.

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.
Denis Varshavsky

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.