insert excel data to sql server table

Question

i want to insert bank statement into sql server table by selecting which table i want to import the data to sql server table

Jignesh Kumar · Answer

Hi Manoj, Please use below link if you want to improt Excel records to sql table, https://www.c-sharpcorner.com/article/how-to-import-data-from-excel-data-into-sql-table/

Puneet Kankar · Answer

Hi Manoj, Please check the below link to insert excel data to the SQL server. These references give you multiple ways to insert data to SQL server. https://docs.microsoft.com/en-us/sql/relational-databases/import-export/import-data-from-excel-to-sql?view=sql-server-ver15 https://www.c-sharpcorner.com/article/how-to-import-data-from-excel-data-into-sql-table/ https://stackoverflow.com/questions/27506143/insert-data-into-sql-table-from-an-excel-sheet https://www.c-sharpcorner.com/article/import-excel-data-into-sql-table-using-sqlbulkcopy-in-c-sharp/

Sachin Singh · Answer

follow this https://www.c-sharpcorner.com/UploadFile/0c1bb2/inserting-excel-file-records-into-sql-server-database-using/

Manoj Mandal · Answer

can i integrate sql import wizard in asp.net website

Leon D · Answer

You can use Free Spire.XLS library to export excel to data table, then insert data table to sql server dadabase. https://www.e-iceblue.com/Download/download-excel-for-net-free.html (also available on nuget) The following is the code example shows how to export excel to data table: Workbook workbook = new Workbook(); workbook.LoadFromFile(@”Sample.xlsx”); Worksheet sheet = workbook.Worksheets[0]; DataTable dt = sheet.ExportDataTable();

Srinivasan Ramamoorthi · Answer

https://www.c-sharpcorner.com/blogs/how-to-import-excel-data-in-sql-server-using-asp-net2

Srinivasan Ramamoorthi · Answer

You can use excel interop dlls or aspos

Manoj Mandal · Answer

i want to implement in web application

Srinivasan Ramamoorthi · Answer

You can use sql server import and export wizard. Select excel as source and sql table as destination.