Update and save changes to access database

Help
1

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

uip%20example
uip%20example418×530 24.3 KB

2

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

3

Insert datatable activity

Cheers

4

It works:) thank you

rgrds
Jakub

1 Like
5

Cheers @jakubwawaurs

6

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