How to create a database from a table

Hi, I’d like to put some data from an Excel file into a Database in KNIME so that I can use SQL query nodes on it. I’m struggling with it, because all of the database nodes seem to require a database as an input. This seems like it should be really simple, but I can’t seem to figure it out. Can someone help me figure this out?

You could start with the upper part of this workflow. Loading a KNIME table into a data base

In the link section there is a link to the database guide and there are more examples on the hub

1 Like

Hello @stevelp,

you can not create a database from table. You can write table to already existing database. And to do that you need to obtain a database connection…


1 Like

This is exactly what I needed. Thanks!

1 Like

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