Hello,
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