Icon

F6_​EA_​Sales_​to_​Access

<p>21-Jul-2026</p><p>Move to</p><p></p><p>Files/Folders Path</p><p>\\192.168.0.161\VB-Share\EA\SalesOrder\PI</p><p>\\192.168.0.161\Vanguard_all\01-Eric\DB\Access_SalesOrder.accdb</p>

21-Jul-2026

Move to

Files/Folders Path

\\192.168.0.161\VB-Share\EA\SalesOrder\PI

\\192.168.0.161\Vanguard_all\01-Eric\DB\Access_SalesOrder.accdb

Check if the orders exists.

If it does, remove the order from the database.

Retrieve header and row-level information from each file.

Email

Uploading Sales Orders to the Database

v3.0

Combine all files into a single dataset.

Connect to the MS Access database.

Write the combined data to the database.

Move the processed Excel files to an archive folder.

DB Writer
Wait...
Number to String
Duplicate Row Filter
Loop End
Microsoft Access Connector
List Files/Folders
Python Script
Transfer Files
Component
Wait...
Table Row to Variable Loop Start
Excel Reader
Loop End
Metanode
Latest Record Selection
Metanode
Table Row to Variable Loop Start
Metanode
Variable Expression
Send Email
Date&Time Configuration
Joiner
Microsoft Access Connector
Excel Reader
Excel Reader
DB Delete (Filter)

Nodes

Extensions

  • No modules found

Links

Download

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

Download Workflow
Created by: knime
Created at: 2025-04-17
On NodePit since: 2026-07-22
Last update: 2026-07-22
Created with KNIME version: v5.11.0

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

Try NodePit Runner!