exporting excel tablefield with 2000 characters into access db does not work

[mlauber71]

@Heinz if you want to store huge text fields you can use the MEMO format in MS Access.

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