Load the imported excel data to a Database like SQL server

Hello Community, I am new to Mendix and still learning to develop something that aligns with our requirements.   One part of the requirement is to give a flexibility to the team to import an excel based on a format and then once the data is imported to the Mendix layer, I need to load the data to another database like SQL Server…   If anyone could help that would be great!.. Thanks in advance
1 answers


First you have to import the DatabaseConnector module to your project https://marketplace.mendix.com/link/component/2888


Now you need to build your own SQL query statement to execute via the ExecuteQuery or ExecuteStatement Java actions from DatabaseConnector module.

ExecuteStatement is used to INSERT, UPDATE, DELETE & DDL queries.  


For more details refer this https://docs.mendix.com/appstore/connectors/database-connector/


Hope it helps!