export Excel Sheet to Oracle database

Please provide information about the method - the software used - the source code in the case of exporting the excel sheet content to the prepared / created table on the database in Oracle. I am particularly interested in using this method in vba

@pszpadro welcome to the KNIME forum

There is an Oracle Connector – KNIME Hub to access a database.

Here are a few examples how you could work with KNIME and SQ/databases

KNIME and databases and SQL

H2 und SQL: Example how to use H2 database to create table with upload and from scratch – KNIME Hub

Not sure what you mean with that. Id od not think that KNIME and VBA would work closely together and a tool like KNIME should be able to substitute a lot of VBA functions.