How to write data in to Access Database


I want to extract my data from Knime to the MS Access database. I am very new to it and not sure how to proceed. Could someone help me here, please? I want to push the same Access data to Power Bi to prepare the dashboards.

Which Knime nodes are to be used to write the data into Access DB and how to get the server name and table names to import into Power Bi? Is there any easy process to do it? And how to set up an Access Database connection.

Thank you,

@Samir_Nagure for MS Access you can take a look at the examples

To send data to Power BI there is a node for that

You can use a Microsoft authentication to get access like in this example

1 Like