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

0
votes

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?

1
asp.netasp.net-mvcentity-frameworklinq-to-sqlc#-4.0
haacked.com/archive/2010/07/16/… I got a link but unfortunately It just tell me to upload it to the server,It does not supply file to the Model Binder from where i can Extract the File. – RL89
Model binder will not come to picture in this case. You upload the file to server and then process excel the way you want. – Pradeep

1 Answers

3
votes

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.