I have an old DDE server application from which I can request relevant information, currently by using MS Access DDE functions and saving in SQL Server tables. Ideally I would like to remove this process from the client workstation and create an SQL stored procedure to download the info. directly. Can anybody point me in the right direction to achieve this ?

Any assisitance would be greatly appreciated.

TIA

Steve Baxter