how to SqlBulkCopy using different column between excel and dabase table

Question

Can anyone tell me how to add data using excel data with 3 columns into database table that has 9 columnsIm using this tutorial to bulk my dataFYI Im totally newbieThanks amp Regards

Shashikant · Accepted Answer

HiYou need to map the Column name link below as Given in articlesqlBulkCopyColumnMappingsAdd34Id34 34PersonId34sqlBulkCopyColumnMappingsAdd34Name34 34Name34sqlBulkCopyColumnMappingsAdd34Salary34 34Salary34I hope this will help you out

nanonano06 · Answer

I found the issue it seems that I misstype the column name Shshikant thanks for your attantion and help

how to SqlBulkCopy using different column between excel and dabase table

Company

Explore

Follow us

Contact Us