How To Save SQL Results to Excel on Schedule

Answered

Apollo Cherniak

• October 15, 2019 14:35

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.

Vote

0

• Official comment

  

  Yaremi Miranda Lopez

  • February 17, 2020 15:54

  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

   
• 

  Apollo Cherniak

  • October 16, 2019 15:51

  bump

Please sign in to leave a comment.