You could create or import a table as a meta table and use a loop to make the task. I collected a few maybe helpful links about that.
If you have large or complicated operations you might want to include a check if your transfer was successful.
KNIME course about loops
@armingrudd articles about loops and flow variables
Nodeguide to loop examples
Special loop example involving data bases
3 Likes