Hi folks,
Please help me if anybody here knows how to connect to Access db from KNIME,
I have problem in writing the data back to MS Access database, Please help me.
I tried to read the data from MS Access DB everything was fine.
Now when I'm trying to write the data back to the same DB after some transformation, I'm getting this error ERROR Database Writer 2:19 Execute failed: UCAExc:::4.0.1 unexpected token: STATE required: (
Here I'm attaching the image of the KNIME workflow of what I'm trying to do (And that's how I'm configuring), Please find it.
I'm sure I have missed something, Please help me correct that.
Thank you.