Load Excel File Dynamically Into Database Using SQLBulkCopy and GetOleDbSchemaTable in C#
February 24, 2012
Previously, I have posted some SSIS solutions which would handle dynamic column mapping in data loading. This time, I was wondering how to handle dynamic column mapping when the source is an excel file. I was quick to realize that it would be entirely a C# solution and the program should be able to handle … More Load Excel File Dynamically Into Database Using SQLBulkCopy and GetOleDbSchemaTable in C#