insert excel data to sql server table

Manoj Mandal

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

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manoj Mandal4y ago
can i integrate sql import wizard in asp.net website
+1
Leon D4y ago
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();
+1
Jignesh Kumar4y ago
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/
+1
Puneet Kankar4y ago
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/
+1
Srinivasan Ramamoorthi4y ago
https://www.c-sharpcorner.com/blogs/how-to-import-excel-data-in-sql-server-using-asp-net2
+1
Srinivasan Ramamoorthi4y ago
You can use excel interop dlls or aspos
+1
Sachin Singh4y ago
follow this
https://www.c-sharpcorner.com/UploadFile/0c1bb2/inserting-excel-file-records-into-sql-server-database-using/
+1
Manoj Mandal4y ago
i want to implement in web application
+1
Srinivasan Ramamoorthi4y ago
You can use sql server import and export wizard. Select excel as source and sql table as destination.
+1