I want to import the contents of an Excel file into SQL using knime software I also want to retrieve information from SQL through knime and import it into Excel Please tell me the nodes of this issue in the form of a picture
Hi @Sina36 and welcome to the KNIME community.
For the first part of your question, please see the following thread
For the second part, there is no one way to read from the database, and it Helens what you are trying to do so I would suggest taking a look at the db extensions guide
https://docs.knime.com/2019-06/db_extension_guide/index.html#intro
But as a quick start overview, there are some useful videos available:
3 Likes
Lol… Anybody wondering what “Helens” meant in the middle of that post… It was supposed to say “depends”, but too late to edit
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.