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