I have task to create custom page. Ideally custom need to have upload button functionality, on click of upload button user need to select an excel file, once user uploads it. I need to parse the data in excel and save the data into sql server table.

what is correct approach for this kind of requirement? Should I start creating a application page using VS2010?

Environment SharePoint 2010/ MS SQL Server. Thanks.

Four years ago I might have said an application page was a good idea. However it sounds like this functionality will be hosted in SharePoint but is not really concerned with it; it's parsing a file into a completely different SQL Server table?

If at possible I'd develop this outside of SharePoint, as an ASP.NET app for example, perhaps with an iFrame in SharePoint to surface the app to users.

I suggest this because the whole development paradigm in SharePoint is moving away from Full Trust solutions wherever possible, and there's no point installing solutions to the SP server that don't need to be there, for performance, maintenance, and upgrade re