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:
And in some cases, you may have to do some data processing/manipulation before writing:
That’s basically it
2 Likes
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.