While insert the data excel to database

[Shyam_Pragash]

Hi,

i want to update the data excel into sql Server as per the format.

Excel File Heading:

Sql Server Table Details: (we have have permission to change the columns Name)

I try to insert one column value into the sql server.

Parameter also passed.

Thanks
Shyam

[supermanPunch (Arpan)]

@Shyam_Pragash

I try to insert one column value into the sql server.

Hi @Shyam_Pragash ,

Are you facing an issue/error when performing this step ?

Could you share the error message if present ?

Also, Try providing Square Brackets to Column Names which contain spaces like [Ticket ID].

[Gokul001 (Gokul Balaji)]

Hi @Shyam_Pragash

Have you tried with Update query syntax

"UPDATE HF_master_1 SET Ticket ID = ('"+Ticket_ID+"') WHERE id = ('"+UserID+"')"

UserID -> Unique reference number

Regards
Gokul

[Gokul001 (Gokul Balaji)]

HI @Shyam_Pragash

Try with this expression

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

Regards
Gokul

[supermanPunch (Arpan)]

@supermanPunch

Also, Try providing Square Brackets to Column Names which contain spaces like [Ticket ID].

@Shyam_Pragash ,

As mentioned already, Did you try with Square Brackets ?

[Shyam_Pragash]

Hi @Gokul001 @supermanPunch

i will check the update u…

Thanks
Shyam

[Anil_G (Anil Gorthi)]

Hi @Shyam_Pragash

Please try like this

Insert into tablename ([ticket id]) ….

Alternately try including the parameter between songle quotes

(‘@ticket_id’)

Cheers

[Gokul001 (Gokul Balaji)]

@Gokul001

Try with this expression

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

Have you tried like this ? @Shyam_Pragash

[Shyam_Pragash]

Hi @supermanPunch @Anil_G @Gokul001

Thank You all

“INSERT INTO HF_master_1 (”“Ticket ID”“) VALUES ('”+Ticket_ID+“')”

This is working.

Thanks
Shyam