[Imported] Scheduled task

[sbeadle]

>>Message imported from previous forum - Category:General Items<<
User: andrew, originally posted: 2019-05-29 14:49:31 Id:438
Good morning, I have been tasked with creating a scheduled task (windows task scheduler) to automatically write data to an excel sheet on a file server every hour. Normally I would write a sql query in excel to pull this in but that has to be refreshed manually. does any know a good way to do this?

[sbeadle · Accepted solution]

>>Responses imported from previous forum

Reply From User: adamwoodland, posted: 2019-05-29 20:09:31
Bit of VBScript using the older COM ClearSCADA automation interface, and then using the relevant COM Excel objects if they still exist, should do the trick.

Alternatively you could use the SQL Export driver the generate the data once an hour and then some Excel magic to import them, for example on Excel load.