mardi 28 février 2017

C# MVC upload CSV file & import it to SQL server by creating table dynamically

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 MVC-3 & SQL Server 2014 standard version.Please let me know the best possible ways of achieving this.

Thank you.

Aucun commentaire:

Enregistrer un commentaire