I'm attempting to automate a process at my job where we import data into an Access Database, run a series of queries to modify the data, then export the modified data. What I'm attempting to do is ...

I need to be able to run a vbscript at night to export the contents of an Access DB to an Excel spreadsheet. Any suggestions how to do this?

Within Power Automate, it has been possible to run scripts in Excel using the Run Script action. Did you know that there is a Run Scripts from SharePoint library action too? Office scripts are similar ...