CODEWITHSUNDEEP
asp.netasp.net-mvcentity-frameworklinq-to-sqlc#-4.0
RL89
RL89

Reputation: 1916

Upload Excel File and Extract Data from it and put that data in database using MVC asp.net

I want to upload an Excel File using (HTML.Input) in some folder in server and also want to extract data from it and put that data in database. So Is there any smart way in MVC Asp.net to upload and extract and then put data in database?

Upvotes: 0

Views: 2649

Answers (1)

Pradeep
Pradeep

Reputation: 3276

There is no such smart way. You will have to:

  1. Upload the file.
  2. Connect to Excel using existing ODBC mechanism. Find out connection string for excel.
  3. And do the processing accordingly.

Upvotes: 3

Related Questions