How to Insert excel data into database

Hi

I have an excel sheet contain data, using the read range activity store in a data table variable(vDT).
Using this data table variable(vDT) trying to insert in the database.
image
the above one I tried, got an error
image

Please explain how can I work on it

1 Like

Hi,

The column ‘MACHINERY’ may not be available in your database or check the datatype for the same column.

1 Like

Hi @sudhasagar,

Take a look this one with example.

Regards
Balamurugan.S

2 Likes

Avoid using any Space or special characters for header names of the database table. Also ensure that header names in the excel sheet is same as that of the table in the database

1 Like

Hi
The sequence of steps are missing in the work flow.
So, please kindly explain in step by step process.
The main object is read the excel and store in datatable variable and put this datatable variable in a database of sql

Hi,
Actually, i want read the complete excel and store in a datatable variable.
This Datatable variable should insert in a sql database.
So,please explain in process of steps