Insert excel data to database table

Hello Team,
How to insert excel data in database table?

Thank You,
Vaishali Khole.

Hi Vaishali,
You will primarily need two steps: Microsoft Excel Input and Table Output
A very basic version of your workflow will look something like this:

Add Database Connection details as per your need. Add your schema name in 1 and the exact table name in which you want to enter the data in 2.

As a next step, click on Get fields and the map them to your Stream Fields i.e. Fields coming in from Excel

Hopefully this helps.

Thank You @hemanshu.rukadikar

1 Like