After my process reads data from excell sheet I separate it and store it in some variables.
Now , I have to insert that data from variables into my database.
I have connected to database and I am using Execute Non -Query activity, but getting error i guess I am missing something so it is not able to insert. i attached my process and excel sheet
help me to solve this problem??
Main.xaml (57.5 KB) aaa - Copy.xls (25 KB)
can you put the whole query up please
Just post your insert query here which you wrote in execute query activity.
hi @Karun @Jersey_Practical_Sho
" Insert Into [epic_icr].[dbo].[ndb] (
RM_AgentName
,RM_AgentCode
,SELECTSERVICE
,SelectTypeof__Account
,AccountHolderName_Primary
,Customer__IdentificationNoCIN_Primary
,AccountHolderName_Joint
,Customer__IdentificationNoCIN_Joint
,AccountNickname
,Obtaincustodialservice
,CustodianBankName
,RegularSavingsorRegularWithdrawals
,TransferallWithdrawalsto
,NameoftheBank
,NameoftheBankBranch
,BankAccountNo
,BankAccount__Name)
values ( RM_AgentName,RM_AgentCode,SELECTSERVICE,SelectTypeof__Account,AccountHolderName_Primary,Customer__IdentificationNoCIN_Primary,AccountHolderName_Joint,Customer__IdentificationNoCIN_Joint,AccountNickname,Obtaincustodialservice,CustodianBankName,RegularSavingsorRegularWithdrawals,TransferallWithdrawalsto,NameoftheBank,NameoftheBankBranch,BankAccountNo,BankAccount__Name)"
Needs to be formatted as the below example
"Insert Into UiPath.EmailLog (Email_id,Sender,Received,No_Attachments) Values ('"+EmailID.tostring+"','"+EmailSender.tostring+"','"+EmailRec.tostring+"','"+NoAttach.tostring+"')"
I guess you need to keep RM_AgentName,RM_AgentCode,SELECTSERVICE,…etc values in single quotes.
Hello,
you use [epic_icr].[dbo].[ndb] table or [epic_icr].[dbo].[ndb1]
as per shown in screen shot you had used ndb1 table and in query you use ndb table.
Thanks,
Sunil Patel.
Can you change the datatype from nvarchar to varchar in database?
and give it a try with the same single quote formatted query…
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.