I am creating an application which will upload data from Excel to SQL Server using ASP.NET. I know how to upload Excel data using
SqlBulkCopy. But I am trying to upload some extra data for the table column (
addedby...etc) which is not present in the Excel sheet.
I get this error:
The given ColumnName '18-01-2016 17:24:07' does not match up with any column in data source.