I am struggling with database connection to MS Access files.
I followed some guidelines/manuals through Google. but It failed.
I copied and pasted ucanaccess-4.0.2.jar into C:\Program Files\KNIME\jre\lib\ext.
And I closed and opend KNIME application.
However, I can not see ucanaccess in the drive list of Database reader.
I attached 2 pictures for understanding.
Thank you in advance.
Click on file>preferences<databases and add the corresponding Jars.See the image below
you still have to add the driver in the preferences: https://www.knime.com/database-documentation
I'd like to add an existing forum-discussion about this specific issue, which contains a comprehensive guide how to connect KNIME with MS Access: https://www.knime.com/forum/knime-general/no-connection-to-ms-access-database
Hope that helps.
if you have troubles connecting to a MS Access database have a look at the following post: