My customer wishes to view some SQL data in Excel.
I can write a stored procedure or even a view (no parameters) to query the data they require.
Would they be able to just open the view/call the stored procedure from within Excel - if so from where? Or would I need to code a VBA button on the spreadsheet or other solution?
Many thanks in advance
View Complete Post