Amending an ODBC link in a spreadhseet

shabbaranks · #1 10-25-2018, 09:06 AM

Hi,

I've got a spreadsheet which connects to an SQL DB to query data using an ODBC 10.0 connection as per the picture. The connection WSID refers to a server which I want to decommission. I would like to use another server connection but I cant change the connection settings.

Can anyone help please?
Thanks

ArviLaanemets · #2 10-25-2018, 11:40 AM

I always use a Datasource defined for computer.

Code:

DSN=MyDatasource;
UID=MyLogon;
Trusted_Connection=Yes;
APP=Microsoft Office 2013;
WSID=MyComputerName;
DATABASE=MySqlServerDB

All real connection info is defined in Datasource. When the server must be changed, I update the datasource, and this it all. I always can save a Registry Editor file to do this - and I can run the Registry Editor file on any computer to update identical datasources on various computers.

shabbaranks · #3 10-26-2018, 12:06 AM

Thanks, if I change the data connection on the spreadsheet does that mean I'll need to change the pivot tables and the like?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Populate Word document from Excel spreadhseet	shabbaranks	Word	1	10-09-2017 05:22 AM
Amending dates and recalculating duration	seanpears99	Project	1	12-03-2012 07:18 AM
Amending templates on a Mac	graham	Word	0	01-05-2012 10:12 AM
Outlook address book & ODBC	dhaven	Outlook	0	12-19-2011 11:26 AM
DDE, OLE DB, or ODBC?	timorrill	Mail Merge	0	01-21-2009 01:42 PM