Hi,
We have posted an interesting tutorial regards connecting Excel to a Remote SQL Server database hosted on a Web Server.
The example demonstrates editing table data - but the same principle can be used to Report or Process data.
The tutorial refers to the EDT application - however the configuration is generic and details the technical steps in order to achieve this goal.
How to securely connect Excel to Remote Web Server SQL Server Database
http://www.leansoftware.net/en-us/he...eb-server.aspx
Regards
Bookmarks