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

Anil_G (Anil Gorthi) November 25, 2022, 7:21am 9

Please try like this

Insert into tablename ([ticket id]) ….

Alternately try including the parameter between songle quotes

(‘@ticket_id’)

Cheers

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