I am not on a Windows machine but successfully connected to an MS Access database accdb file in KNIME. In the table reader node, I see that KNIME is able to identify the tables. Is it possible to pull out that list of table names and read in the data for each one into a table?
@Brock_Tibert yes that is possible. You can query the information schemas
5 Likes
Fantastic thank you! I never use Access and my web searches to query the schema were not yielding any results that worked. I appreciate it.
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.