write to msaccess database

[mlauber71]

@sanderlenselink you could try the standard driver

Access Databases - [lnet.ucanaccess.Complex.SingleValue]

This is because these are multivalue fields and the driver seems to struggle with extracting them. You although can use UCanAccess driver and in this case Python to extract the values. I wan not able to integrate the driver directly into KNIME so I went with Python instead. Should run on macOS and Windows machines. [image] You will have to modify the code though to extract your fields and databases but it should show you how this can be done.

You sample file does not include any data. You could try and use DB Insert instead of Write and see if that makes a difference.

demonstrates the use of DB Update and DB Merge with MS Access DB – mlauber71

Also you can try this example based on your case:

msaccess_test1.knwf (127.6 KB)