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