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?
Answers:
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
Method 1
There is no such smart way. You will have to:
- Upload the file.
- Connect to Excel using existing ODBC mechanism. Find out connection string for excel.
- And do the processing accordingly.
All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0