karan.kalia
New Member
Hello All
I am working on updating the excel using oledb query it is working for other cells but for one cell updation it is giving error as "Internal : Could not execute code stage because exception thrown by code stage: No value given for one or more required parameter"
Connection string : "Provider=""Microsoft.ACE.OLEDB.12.0"";Data Source=""" &[global_coll_Config_File.Local_Folder] & "\" & [global_num_CurrentYear] & "\" & [global_txt_CurrentMonth] & "\" & [global_num_CurrentDate] & "\" & [global_coll_Config_File.Report]& """;Extended Properties=""Excel 12.0;HDR=YES;"""
Update Query : "UPDATE ["&[txt_PreviousMonth]&"$A2:Q] SET [Comment Value]='"&
[ip_txt_CommentValue]&"' WHERE [Sales Category Name] ='"&[coll_TemplateExcel.Sales Categories]&"' AND [Dept] ='"&[ip_WorksheetName]&"'"
The above query is giving me issue and below is the query which is working perfectly fine.
"UPDATE ["&[txt_PreviousMonth]&"$A2:Q] SET [AMOUNT]= '"&
[coll_TemplateExcel.Amount]&"' WHERE [Sales Category Name] ='" &[coll_TemplateExcel.Sales Categories]&"' AND [Dept] = '"&[ip_WorksheetName]&"'"
All the Column are General format except Amount and Comment Value.
Please help me in finding the real issue for the above error
I am working on updating the excel using oledb query it is working for other cells but for one cell updation it is giving error as "Internal : Could not execute code stage because exception thrown by code stage: No value given for one or more required parameter"
Connection string : "Provider=""Microsoft.ACE.OLEDB.12.0"";Data Source=""" &[global_coll_Config_File.Local_Folder] & "\" & [global_num_CurrentYear] & "\" & [global_txt_CurrentMonth] & "\" & [global_num_CurrentDate] & "\" & [global_coll_Config_File.Report]& """;Extended Properties=""Excel 12.0;HDR=YES;"""
Update Query : "UPDATE ["&[txt_PreviousMonth]&"$A2:Q] SET [Comment Value]='"&
[ip_txt_CommentValue]&"' WHERE [Sales Category Name] ='"&[coll_TemplateExcel.Sales Categories]&"' AND [Dept] ='"&[ip_WorksheetName]&"'"
The above query is giving me issue and below is the query which is working perfectly fine.
"UPDATE ["&[txt_PreviousMonth]&"$A2:Q] SET [AMOUNT]= '"&
[coll_TemplateExcel.Amount]&"' WHERE [Sales Category Name] ='" &[coll_TemplateExcel.Sales Categories]&"' AND [Dept] = '"&[ip_WorksheetName]&"'"
All the Column are General format except Amount and Comment Value.
Please help me in finding the real issue for the above error