@Newbie Thanks for reaching out. Azure Logic Apps/Data factory can be used to process Excel files, but it may not be a direct replacement for an MS Access app. Azure Logic Apps/Data factory provides a way to automate workflows and integrate with other systems, but it may not have the same level of data processing capabilities as MS Access. However, you can use Azure Logic Apps in conjunction with other Azure services, such as Azure Functions or any other service, to process and manipulate data from Excel files.
If you have an MS Access app that processes Excel files with unknown fields, you can use Azure Logic Apps to automate the process of uploading the Excel files to a cloud storage service, such as OneDrive or SharePoint, and then use Azure Functions or any other service to process the data.
Once the file is uploaded to OneDrive or SharePoint you can use Create Table action to create the table on you excel. For transformation of data there are many function reference that can be leveraged to transform your data based on your business logic. Post transformation of data you can leverage Update row, delete row, add row etc. on your table.
Please refer to know issue and limitation of connector before you are creating your workflow.
To know more about trigger/action available in excel online connector please refer to this document.
For excel processing using Azure Data factory please refer to this document.
Feel free to get back to me if you have any queries or concerns.
Please accept as "Yes" if the answer is helpful so that it can help others in the community. If you need any help/clarification/concerns/follow up questions, then please click on "Add Comment" on my answer and provide more details.
Thanks!