Server swap & ODBC DNS refreshing
I'm currently in the process of a server swap and need to refresh
hundreds of Excel documents to point to the new server. I can change the ODBC data source quite easy (just by changing the SQL Server, leaving the name the same). And I understand that Excel stores this off when the query is created, that I need to refresh this connection to repoint at the new server. The only method I can see at the moment it to "Edit Query" on each one and cut&paste the SQL into a new Query in MSQuery. Is there any method to auto refresh the DataSource in the Excel? I've had a search and have been looking at "?Sheet1.QueryTables(1).Connection", but because the DSN name is the same I'm not sure what I need to do to refresh this? |
All times are GMT +1. The time now is 11:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com