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

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

Hi @sudhasagar , Take a look this one with example. [image] Insert SQL with variable / parameter giving error in ExecuteNonQuery activity Help Hi @ramawat , I made a test what @Pablo_Sanchez mentioned with a little table. It is working fine. can you attache the table scrip…

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

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

How to Insert excel data into database

Help

balupad14 (Balamurugan (BalaReva)) October 8, 2019, 6:18am 3

Hi @sudhasagar,

Take a look this one with example.

Regards
Balamurugan.S

Topic		Replies	Views
Insert Excel values into Database Studio excel , database , activities	1	877	July 24, 2020
Read data from excel sheet dynamically and push to SQL Help excel , database , activities	25	5296	October 23, 2019
How to read data from excel then create table in sql database using excel column of excel file & insert data into that table Certification excel , database , activities	2	1825	July 23, 2020
Excel read range to insert into a database Studio datatable , excel , database , activities , studio , question	2	1125	August 2, 2020
Inserting Excel file into Database Help datatable , excel , database , activities , error	29	2308	February 7, 2024

How to Insert excel data into database

Related topics