how to SqlBulkCopy using different column between excel and dabase table

Hi,

You need to map the Column name link below as Given in article

sqlBulkCopy.ColumnMappings.Add("Id", "PersonId")
sqlBulkCopy.ColumnMappings.Add("Name", "Name")
sqlBulkCopy.ColumnMappings.Add("Salary", "Salary")

I hope this will help you out.

I did that, but when I debug the code it shows error something like the destination table and source table are not match up.

FYI: My excel columns are 3 and my sql table columns are 8(so I think it's because of that)

Hi,

Make sure that all other column must be nullable for which you are not passing value or they must have default constraint

I hope this will help you out.

I found the issue, it seems that I misstype the column name.

@Shshikant: thanks for your attantion and help :)