Bulk Update: No value given for one or more required parameters


I am trying to update my access database with ‘Bulk Update’ activity, but I keep getting this error: Bulk Update: No value given for one or more required parameters.
Activity is set up as shown bellow:

The goal here is as follows:
-get data table from access DB
-update a status column
-update access data base with new values of status column.
may be there is another approach to this?

Hi @Tadas ,

I am not really sure if we would require to get the Datatable, Update and Update the Table in Database. Instead of this, Could we Try to Update the Values in the Database Directly using Execute Non Query Activity ?

Is there a Reason why you have opted for this method ?

I guess the reason would be the lack of experience :slight_smile: how would one use execute non query activity for this particular task?

@Tadas , If we do have to Update Column Values based on a Condition we could use the Below Syntax to create the Sql Query and use it in the Non Execute Query Activity :

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

Example :

SET column1 = value1, column2 = value2
WHERE column1<10;

Some other Posts Supporting the Query :

1 Like

Great thanks a lot, that worked!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.