how to import excell to sql

Hi Smitha,

Check the following article

https://docs.microsoft.com/en-us/sql/relational-databases/import-export/import-data-from-excel-to-sql?view=sql-server-ver16

https://www.sqlshack.com/import-data-excel-file-sql-server-database/

https://www.youtube.com/watch?v=JVP9frj2VSQ

You can read data in Excel worksheet to a datatable with ease using free spire.xls library (https://www.nuget.org/packages/FreeSpire.XLS), then save the datatable to database.

Workbook workbook = new Workbook();
workbook.LoadFromFile(@"F:\Data.xlsx" , ExcelVersion.Version2013);            
Worksheet sheet = workbook.Worksheets[0];
DataTable dt = sheet.ExportDataTable();

For more information, visit this link:

https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Import/Export-Import-Data-from-Excel-to-Datatable.html