Question: how to export table data to excel in sql server 2012?
Answer: Right-click on the name of the database instance you want to use, and select Import Data from the Tasks menu. Click Next. Choose Microsoft Excel as the data source (for this example). Click the Browse button, locate the address.