Loading

Excel file data not getting inserted into SQL database.

SANJAY KUMAR

Dear sir/madam,

please refer my attached source code, I'm getting an error while trying to insert the excel data into SQL database. So please requesting you check and do the needful.

Excel version: 2013

thanks,

sanjay JP

2 Replies

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

Rafnas T P8y ago
hi,
check your column names in excell sheet and in the code should be same.

I have an article for this in case you need any help please go through below link

https://www.c-sharpcorner.com/article/import-excel-data-into-sql-table-using-sqlbulkcopy-in-c-sharp/

Thank you
0
Leon D8y ago
You can take a look at spire.xls library, by which you can easily export excel data to data table with several lines of code.

https://www.nuget.org/packages/Spire.XLS/

Code to export excel to data table:
Workbook workbook = new Workbook();
workbook.LoadFromFile("Input.xlsx");

Worksheet sheet = workbook.Worksheets[0];

datatable = sheet.ExportDataTable();
0