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.
You can try below solution to insert constant values like addeddate, addedby...etc.
SELECT EXCEL_COL1, EXCEL_COL2, 'newconstantvalue' as CustomCol FROM ExcelSheet1 Then bulkCopy.ColumnMappings.Add("Table_COL3", "CustomCol");
Please refer the article for more detail.