How to Insert excel data into database

[sudhasagar (sagar)]

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.

the above one I tried, got an error

Please explain how can I work on it

[sarathi125 (Parthasarathi)]

Hi,

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

[balupad14 (Balamurugan)]

Hi @sudhasagar,

Take a look this one with example.

Insert SQL with variable / parameter giving error in ExecuteNonQuery activity

Hi @ramawat, I made a test what @Pablo_Sanchez mentioned with a little table. It is working fine. can you attache the table script and your insert query as a zip file. May be it helps to do the analysis. But any way, Here I have attached xaml and table for your reference. SqlServer.zip (2.7 KB) Regards Balamurugan.S

Regards
Balamurugan.S

[diptojyotidutta]

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

[sudhasagar (sagar)]

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

[sudhasagar (sagar)]

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