查看我过去的回答：导入excel到db with file path [ ^ ]。我建议使用 SqlBulkCopy类 [ ^ ]，它可以启用列映射。



请参阅： SqlBulkCopy.ColumnMappings属性 [ ^ ]

SqlBulkCopyColumnMappingCollection Class [ ^ ]

See my past answer: import excel to db with file path[^]. There i suggested to use SqlBulkCopy class[^], which enables columns mapping.

Please, see: SqlBulkCopy.ColumnMappings Property[^]
SqlBulkCopyColumnMappingCollection Class[^]