Knime data upload to Access database.

KNIME Analytics Platform
1

Hi Everyone,

Hope ya’ll are safe!

I have a quick query to ask about Access database.
When we try to load data from knime to Access we have some sort of characters limit of 255, Can we increase the character limit for the same?

Thanks!

2

Hi @ManishaDM -

I think this is something you can change on the Access side. See here:

Having said that, I would highly encourage you to move to a different database to store data, even a local file-based one like H2 (which KNIME supports: H2 Connector). Access has many idiosyncracies that make it… interesting… to work with.

3 Likes
3

@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
image1592×837 94.4 KB

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
4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.