How To Save SQL Results to Excel on Schedule Answered
I've got a scenario where I'd like to validate if a table has been modified in the last 5 minutes, and if it has, run a SQL report and save the results to an Excel file on the network. There isn't a whole lot of activity in this table throughout the day, but it is overwritten each time it is changed, so I want to capture a snapshot at the time it is changed. There is a linked table that has a timestamp for when the table in question was updated, so that will be my condition.
My question is more geared to how to save the results of a SQL report to an Excel file on a schedule. Thanks.
Comments
2 comments
Hello Apollo,
You can achieve this with the add-on B1 Usability Package with the File exported module. Here is a video that explains how it works.
https://youtu.be/Yzj2ceRk9Io
bump
Please sign in to leave a comment.