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.

You will have to modify the code though to extract your fields and databases but it should show you how this can be done.

1 Like