I have a requirement where we need to import data from a .csv file to SQL server by creating the table dynamically. The reason for dynamic table creation is because the .csv file will have columns changing. We have to drop the existing table & recreate a new table based on the header information in the .csv file. (user may be running some diagnostic queries on that table later on)
I'm using C#.net MVC-3 & SQL Server 2014 standard version.Please let me know the best possible ways of achieving this.