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)
);

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

2 Likes