| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refreshing ODBC data on Protected Sheets | Excel Discussion (Misc queries) | |||
| Changing ODBC server (MySQL) | Excel Worksheet Functions | |||
| SQL Server ODBC Error | Excel Discussion (Misc queries) | |||
| ODBC connection for insert into SQL Server | Excel Programming | |||
| Refreshing data from ODBC automatically? | Excel Programming | |||
Linear Mode
