Can KNIME able to run or connect with MS Access Database?

[mlauber71]

@trafalgarlaw KNIME can connect to a MS Access database and use the data inside, either by loading it into KNIME itself or by sending (SQL) commands to Access to execute the operations you want. You will have to decide if MS Access is actually the right basis for your tasks.

If you want yo can build Data Apps to give people an interface to handle predefined operations, also when accessing databases - it would need some planning and preparation:

Create an Interactive Dashboard with KNIME Components and Python

Knime data upload to Access database.

@ManishaDM if you absolutely must you can use the MEMO format to store larger strings in MS Access: CREATE TABLE SampleTable ( ID AUTOINCREMENT PRIMARY KEY, LargeTextField MEMO, Description TEXT(255) ); [image] kn_forum_72872_ms_access_large_text_variable.knwf (128.9 KB) But as @ScottF has said. You might want to consider using an alternative SQL database