enter Excel data into SQL

[alex1368]

Hello
I want to enter Excel data into SQL through knime nodes and later use sql data to compare data through knime nodes.
Please help me with a picture and tell me which nodes to use.

[takbb]

Hi @alex1368 , re the first part of your question, did you look at this answer that @bruno29a gave last year?

Upload Excel file in sql database

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

Please give that a try and if you need more help on specific aspects, please let us know what problems you are encountering because otherwise we’ll just end up repeating what is already written.

Once you’ve got data in your sql database, I suggest you take a look at the example database workflows at

knime/Examples – 02_Databases

You should be able to adapt these to use sql server if that is what you need. Again if you have difficulty then please come back with specific questions that we can assist with.

[mlauber71]

@alex1368

Excel data into SQL through knime nodes

You could try how this works with a local example using a standalone H2 database

Example how to use H2 database to create table with upload and from scratch –...