I have a table with some data in Management Studio. I am trying to understand how I can transfer data from one table in Management Studio into multiple excel sheets(not multiple excel files). Could you please guide me through this process. The data resides in 3 different categories in the table. Total, Old and New. I would like to have the 'total' transferred into sheet1, 'old' into sheet 2 and 'new' in sheet 3. These catogories are differentiated by filters in my sql command.
Thnaks in advance