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.

insert excel data to sql server table

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (9)