Question: how do you export data from sql to excel?
Answer: Right-click the database in SQL Management Studio. Go to Tasks and then Export data, you'll then see an easy to use wizard. Your database will be the source, you can enter your SQL query. Choose Excel as the target. Run it at end of wizard.