Question: how to import excel sheet in sql server 2012 using query?
Answer: To import data from an Excel file to SQL Server you can use SQL Server Import and Export Wizard. You can also import Excel data using T-SQL OPENROWSET function. OPENROWSET function can be used to import data from and OLEDB data source. I have stored this file in my C:\ root folder.