MS Access Table

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!

Hi @sspi1153

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

image

Regards
Balamurugan.S

1 Like

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?

Hi @sspi1153

Here is the picture presentation to get the package.

Regards
Balamurugan.S

1 Like

Thanks!

1 Like

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