how to transfere an SQL statement to Knime workflow

[mlauber71]

@mi171 knime has a broad variety of options to work with SQL and databases:

https://docs.knime.com/latest/db_extension_guide/index.html#intro

KNIME, Databases and SQL

If you just want to work within knime and with knime nodes that is also an option. The knime/Beginners Space – KNIME Community Hub might be a good point to start.

As @hmfa has mentioned you can also directly work with MS Access itself:

demonstrates the use of DB Update and DB Merge with MS Access DB – mlauber71

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