• Hello,

    Yes, you can achieve this easily using a Foreach Loop and an ADO.NET connection.

    1) Drag a Foreach Loop on your Control Flow.

    2) Click once on your Foreach Loop and create a new variable named TableName of the type String.

    3) Edit your Foreach Loop and go to the Collection section.

    4) Set the Enumerator to "Foreach ADO.NET Schema Rowset Enumerator".

    Under Enumerator Configuration set:

    5) the connection to the ADO.Net Connection which points to your .accdb-file. (or create a new one by choosing "New Connection" from the list)

    6) Select "Tables" as Schema

    Under Variable Mappings:

    7) Choose the variable "User::TableName" and assign index 2

    For each iteration through the loop, the variable TableName will contain the name of a table, which you can use within the scope of the Foreach Loop.