hi,
i want to schedual a query in ms query that runs every day (automatically) at a specific time and then saves the result in an excel file creatig a new file each day and saving it aatomatically..
the purpose is to extract all the sales at the end of the day..
i know that it is possible to schedual a tast with innbuildt excel function but i, not sure if it actaully runs the same ms query or does it actaully runs an update..

can someone please help me with it?