Hi @Dinesh Kumar,
Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.
The primary challenge you're facing is the incompatibility between the ACE driver (used on your local system) and the Jet driver (supported by the Function App) for accessing MS Access databases.
For this We have to alternative for both the type of files.
- If your MS Access database is in the .mdb format, you can directly use the Jet OLEDB provider in your PowerShell script.
- If your database is in .accdb format, consider converting it to .mdb using Microsoft Access or other tools. This will make it directly compatible with the Jet OLEDB provider. By following these steps, you should be able to successfully connect to your MS Access database and extract query data using an Azure PowerShell Function App.
If the issue persists, please do not hesitate to reach out further assistance. If you find this answer helpful, please click "Comment" and kindly upvote it.