excel to sql

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 :wink:

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.