WurzelGummidge
New Member
- Joined
- Jan 24, 2005
- Messages
- 1
Hi
We have recently upgraded our back-office sql server and I have several excel 'Get External Data' queries that point to the old server but need to point them to the new server (tables etc not changed - just server name and ip address).
I have updated the same (existing) ODBC's that I used when i initially wrote the queries but it is still strying to reference the original data source, NOT the data source that is now specified in the ODBC references.
How can I change these please? :x
We have recently upgraded our back-office sql server and I have several excel 'Get External Data' queries that point to the old server but need to point them to the new server (tables etc not changed - just server name and ip address).
I have updated the same (existing) ODBC's that I used when i initially wrote the queries but it is still strying to reference the original data source, NOT the data source that is now specified in the ODBC references.
How can I change these please? :x
