I have a SQL database in Azure. My client wants to be able to connect to one of the tables in excel and update and add to the data from the spreadsheet directly in real time.
Is there a way to do this?
I had created an application in .net using a dataview they did not like it because not all the features that they use in excel are available. Most importantly easily increasing the font size, and filtering the data.
Microsoft ExcelMicrosoft SQL Server.NET ProgrammingVBA