MS Access Table

[sspi1153 (Slavisa)]

Hi there,

I need to perform an activity in MS Access Data Table - it is merely a simple click activity, but it needs to be done for all data rows from the table. My idea is to use a data scraping tool and pull in the table in the database, so I can figure out how many data rows are there. Another option is to check if a certain column is empty for each next data row. If the column is empty =stop a process.

Problem ist that the Data Scraping tool is not working in MS Access. How could I deal with this?
Thanks!

[balupad14 (Balamurugan)]

Hi @sspi1153

It has an activity “Execute Query”. Using this you can able retrieve the data from access.

Execute Query

Regards
Balamurugan.S

[sspi1153 (Slavisa)]

Hi Balamurugan,

thanks for the answer. It seams to be a propert tool for me, but I don´t have that activity in my studio?

[balupad14 (Balamurugan)]

Hi @sspi1153

Here is the picture presentation to get the package.

Regards
Balamurugan.S

[sspi1153 (Slavisa)]

Thanks!