Update and save changes to access database

Hi!

I created a connection with a database containing email addresses. Then I used the for each activity to send e-mails. What i want to do is to add information in existing column, that email have been send. For example- if the first column contains valid email and the message is sent, next column should contain e.g 1 or ‘sent’.
I used the assign activity but it adds value only to virtual datatable (i’ve checked it with write line activity). The accdb remains unchanged.

It have to be access database, i can’t use csv or xslx.

please help:)

rgrds
Jakub

Hi @jakubwawaurs

Welcome to uipath community buddy

we can use an activity called INSERT QUERY which will take the datatable as input and would accept the insert query as string input

For more info on insert query kindly have a view on thisbuddy

Cheers @jakubwawaurs

Insert datatable activity

Cheers

It works:) thank you

rgrds
Jakub

1 Like

Cheers @jakubwawaurs

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