Icon

kn_​forum_​72872_​ms_​access_​large_​text_​variable

Insert large text/string data into an MS Access file with the use of the MEMO format

Insert large text/string data into an MS Access file with the use of the MEMO format


Insert large text/string data into an MS Access file with the use of the MEMO formathttps://forum.knime.com/t/knime-data-upload-to-access-database/72872/3?u=mlauber71 CREATE TABLE SampleTable ( ID AUTOINCREMENT PRIMARY KEY, LargeTextField MEMO, Description TEXT(255)); knime://knime.workflow/data/Finance.accdbsample dataSampleTableSampleTableSampleTablesee that test1is there and emptySELECT * FROM information_schema.tablesWHERE TABLE_SCHEMA = "PUBLIC"SELECT * FROM information_schema.columnsWHERE TABLE_SCHEMA = "PUBLIC"large text field typeMEMOextract storeddataknime://knime.workflow/data/Database1.accdbknime://knime.workflow/data/Database1.mdb Microsoft AccessConnector Table Creator DB Table Remover DB Insert DB Table Selector DB Reader DB Query Reader DB Query Reader DB SQL Executor DB Reader Table View (Labs) Clear all tablesfrom Access File Microsoft AccessConnector Microsoft AccessConnector Insert large text/string data into an MS Access file with the use of the MEMO formathttps://forum.knime.com/t/knime-data-upload-to-access-database/72872/3?u=mlauber71 CREATE TABLE SampleTable ( ID AUTOINCREMENT PRIMARY KEY, LargeTextField MEMO, Description TEXT(255)); knime://knime.workflow/data/Finance.accdbsample dataSampleTableSampleTableSampleTablesee that test1is there and emptySELECT * FROM information_schema.tablesWHERE TABLE_SCHEMA = "PUBLIC"SELECT * FROM information_schema.columnsWHERE TABLE_SCHEMA = "PUBLIC"large text field typeMEMOextract storeddataknime://knime.workflow/data/Database1.accdbknime://knime.workflow/data/Database1.mdbMicrosoft AccessConnector Table Creator DB Table Remover DB Insert DB Table Selector DB Reader DB Query Reader DB Query Reader DB SQL Executor DB Reader Table View (Labs) Clear all tablesfrom Access File Microsoft AccessConnector Microsoft AccessConnector

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: m_lauber
Created at: 2023-09-22
On NodePit since: 2023-09-22
Last update: 2024-04-27
Created with KNIME version: v4.7.7
Tags: MS accessaccessmemolargestringinsertMS

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!