How can I automatically run a query and save to Excel (not using BCP/SSIS)
I have a complex query which I wish to run at a set time every day and save the results to Excel but I cannot find an appropriate solution from a vast amount of Googling. I'm using SQL Server 2012 Express remotely and do not have SSIS. I know I can use BCP but it saves as CSV and doesn't display the data correctly at all. I have not attached the query as it is large but I will if needed. I tried running the query from Excel but it didn't like temp tables. Sorry, if I've missed any info please let me know. Any help would be greatly appreciated.