Pass Dynamic Table Name from via Flow Variable from Microsoft Access Connector

I have a few MS Access file each with different name and different table name into that. I want to read those data dynamically using "List Files/Folders Node. I am successfully reading the MS Access file (DB). But facing difficulties in retrieving the table name to next node.

image

I am new to the KNIME. Please help me ASAP.

@Prashant278 welcome to the KNIME forum. You can list all tables from a MS Access database via the internal storage “information_schema”: You will have to come up with a logic waht you want to do with the information.

If you set a table name somewhere you can extract it later.

https://docs.knime.com/latest/analytics_platform_flow_control_guide/index.html#img-flow-variables-tab-dialog

1 Like

It seems solved but not. :frowning: Still unable to pass the Access file path dynamically.

image

Shows these message.