Hi, there,
Does anyone ever use an excel file or text file to update data in MSSQL.
I know in php, there is such a command to insert data into the database. But I don't know whether there is such a function in ASP.NET.
The reason is that in my project, some information like students information can only obtained from the universal reports which are saved as excel files. To avoid updating each student's information one be one, my boss wants me to incorporate the data from an excel file, like create a web page to upload the excel file, and update all the students' information.
Are there any this kind of functions in ASP.NET or someone ever met this problem before?
Thank you very much
Linear Mode
