how to import excell to sql

Question

Rajanikant Hawaldar · Answer

https://www.c-sharpcorner.com/blogs/import-excel-spreadsheet-data-into-sql-server-table-using-c-sharp https://www.c-sharpcorner.com/UploadFile/0c1bb2/inserting-excel-file-records-into-sql-server-database-using/

Jignesh Kumar · Answer

Hi Smitha Please refer my article which will help you step by step How you can import excel to SQL table https://www.c-sharpcorner.com/article/how-to-import-data-from-excel-data-into-sql-table/

Uday Dodiya · Answer

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

Leon D · Answer

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

Vishal Yelve · Answer

Hi Smitha Check this links Using Query https://www.sqlsplus.com/import-data-from-excel-to-server/ Using Wizard https://www.c-sharpcorner.com/article/how-to-import-excel-data-into-sql-server-2019/