No UCanAccess in database driver in KNIME for MS Access

KNIME Analytics Platform
#1

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.

 

#2

Hi Kim,

Click on file>preferences<databases and add the corresponding Jars.See the image below

Cheers,

Amarendra

#3

Hi,

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.

Cheers,
Marten

#4

Hi,

if you have troubles connecting to a MS Access database have a look at the following post:

https://www.knime.com/forum/knime-general/how-to-connect-to-ms-access-database

Bye

Tobias