Upload Excel file in sql database

Hello serve all friends
I want to import an excel file into sql database What nodes should I use?
Please upload a model for me.

hi @alex1368,

drag and drop the excel file into your workflow, then, if you need to several transformations nodes.
a scql connector node, table creator and insert.

br,
sven

@alex1368 maybe you check out this example. Loading data from KNIME into an H2 database (shoudl work for every SQL DB):

mlauber71
My dear friend, I did not understand your answer
I have an Excel file I want to upload its information to sql server! Please guide me so that I can do this through knime software nodes !!!

Hi @alex1368 , the most basic set up would be this:
image

And in some cases, you may have to do some data processing/manipulation before writing:
image

That’s basically it

2 Likes

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