How to import different format Excel files into a SQL Server database?

Question

I have a requirement where I need to import different Excel files of different suppliers into a SQL Server database. I have created SSRS package for which I need to manually put data in my format, which I have created and then import using SSRS package. What would be the best and fastest way to import different format Excels into SQL Server database using C#?

Answer 1

There is a great company called Aspose, which provides .Net libraries to handle Excel files. You can also use the libraries provided by Microsoft: https://docs.microsoft.com/en-us/dotnet/csharp/programming-guide/interop/how-to-access-office-onterop-objects

Please reach out if you have further questions!