Can Azure Logic App replace MS Access App that Processes Excel File with Unknown Fields

Question

Hello, I have an MS Access database that uses a lot of VB that the customer wants in the cloud.

--The app can load an excel spreadsheet into a database table, do some transformations, create additional tables and then displays a menu of PDF reports.

--The excel spreadsheet is provided by the user.

--There are 3 required fields in the Excel file, but the user can supply other fields which the become part of the report menu selections. So for example if the user includes race and gender in their data, the report menu must contain race and gender as report options.

Is this something that could be done with Azure Logic Apps or a Data Factory? It would be used by the customer so would require access controls, etc.

Answer 1

@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.