Question: how to import data in excel from sql server?
Answer: This will open the SQL Server Import and Export Wizard window:
To proceed with exporting SQL Server data to an Excel file, click the Next button. ... 
From the Data source drop down box, choose the SQL Server Native Client 11.0 item.