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
The column ‘MACHINERY’ may not be available in your database or check the datatype for the same column.
Take a look this one with example.
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)
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
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
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