Jump to content

Scheduled export to Excel

Casper Holt

Recommended Posts

  • 3 months later...

Hi there,


From DV side, you can create a trigger to invoke a Store Procedure / Java Custom Function to export data as csv format (for excel format, it may need more 3rd library under .NET).


Form Excel side, you can make a spreedsheet to load the data from published view via ADO driver, and make a timer through VBA to reload the data from DV. It is easier but the excel needs to opened all the time....


for your reference, hope it helps


Danny Yu from Taipei

Link to comment
Share on other sites

  • Create New...