We have a network of clients accessing excel spreadsheets on a Windows 2003
Server. The speadsheets point at data on SQL Server 2005. Excel installations
on the clients vary from Excel 2000 upto Excel 2007. On each client we create
an ODBC connection using System DSN. This has proved to be a pain to manage.
We are now moving the files to a new server therefore all the ODBC
connections need changing and so do the reports. Is there are better way to
manage these ODBC connections?

Thanks
Danny