Hi, i want to update the data excel into sql Server as per the format. Excel File Heading: [image] Sql Server Table Details: (we have have permission to change the columns Name) [image] I try to insert one column value into the sql server. [image] Parameter also passed. Thanks Shyam

Hi @supermanPunch @Anil_G @Gokul001 Thank You all “INSERT INTO HF_master_1 (”“Ticket ID”“) VALUES ('”+Ticket_ID+“')” This is working. Thanks Shyam

While insert the data excel to database

Gokul001 (Gokul Balaji) November 25, 2022, 6:14am 5

Try with this expression

 INSERT INTO HF_DB.HF_master_1 ("Column Name") VALUES ('"+Ticket_ID+"')

Regards
Gokul

Topic		Replies	Views
Insert data table Column contains space to SQL server Studio datatable , excel , database , studio , question , custom_activity	9	4490	August 6, 2021
Inserting Excel file into Database Help datatable , database , activities , error	29	1963	February 7, 2024
Insert into database Help activities	6	1497	June 20, 2019
Error with DATABASE insert Activity Help activities	15	4032	August 6, 2021
Run command: Column name or number of supplied values does not match table definition Activities datatable , excel , database , studio , question	17	360	June 14, 2023