3 Answers, 1 is accepted
Currently we don't have plans to include an out of the box solution for binding to databases, due to the difference in formats. What you can do however is implement a custom provider, which will provide the interface between the spreadsheet and sql database. I've attached a sample DataBaseProvider, which you can use, and extend to your convenience.
I find the proposed solution to be very applicable to a current client project. Please share any thoughts on how I might refine our technical approach. All work will be done in VS2015 with latest AJAX UI (web forms or Azure web apps) talking to Azure SQL DB.
Current process: (1) obtain client data in Excel CSV format, (2) stage to Access 2016, (3) map incoming fields to standard DW schema, (4) run append query against ODBC link to the table in Azure, pushing local staging table to cloud, (5) do BI stuff
(1) obtain client date in Excel CSV format
(2) use Upload control to copy file into Azure Blob Storage
(3) read XLS file row by row, re-map according to DW business logic, followed by SQL insert, i.e. using slightly modified code from sample DataBaseProvider (a great learning example!)