Hello, dear friends and teachers
I have a series of information about 5 million items in a sql database and I want to add an excel file to it!
Is it possible for you to teach me how and with which knime nodes I can do this.
Hi @alex1368 -
I suppose it depends on the format of both your data and database. If you are just looking to concatenate data to an existing database table (or perhaps write an entirely new table to an existing database), this is fairly straightforward - you need an Excel Reader, the appropriate type of DB Connector, and a DB Writer. Something similar to this:
For more details you can check our docs on the Database Extension.
3 Likes
Hello my dear friend
It’s like I couldn’t understand what I meant
I have a sql table that I saved in sql server and I want to add some more information to this bank in sql server through an excel file.
Please introduce me to the related nodes
In that case you could try something like this. It’s very similar to the example linked above.
Give it a shot and let us know if you have questions.
1 Like
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.