Is there any way to insert records from excel sheet to table in SQL Server

Without Programmatically means, Just use IMPORT data option in sql server or programmatically means


DataSet ds = new DataSet();
String connString = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + FilePath + ";Extended Properties=Excel 12.0;";
objConn = new OleDbConnection(connString);
objConn.Open();
dt = objConn.GetOleDbSchemaTable(
OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });

FilePath is uploaded Excel file

You can refer :

http://www.mikesknowledgebase.com/pages/SQLServer/ImportExcelIntoSQLServer.htm[^]

If you want to insert Using T-Sql Code u can use this..

Exec sp_configure 'show advanced options', 1;
RECONFIGURE;
GO
 
Exec sp_configure 'Ad Hoc Distributed Queries', 1;
RECONFIGURE;
GO
 
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'AllowInProcess' , 1; 
GO
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'DynamicParameters' , 1;
GO
-- Using OpenRowSet
SELECT Sno,Data,Row_Number() Over (Order by Sno) as AutoNumber into #XLImport1 
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
				'Excel 12.0 Xml;HDR=YES;Database=C:\test.xlsx','SELECT * FROM [Sheet1$]');

-- Using OpenDataSource
SELECT * INTO #XLImport3 
FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0',
					'Data Source=C:\test.xlsx;Extended Properties=Excel 12.0')...[Sheet1$]

EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'AllowInProcess' , 0;
GO
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'DynamicParameters' , 0;
GO
 
Exec sp_configure 'Ad Hoc Distributed Queries', 0;
RECONFIGURE;
GO
 
Exec sp_configure 'show advanced options', 0
RECONFIGURE;
GO