#1
|
|||
|
|||
Amending an ODBC link in a spreadhseet
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 |
#2
|
|||
|
|||
I always use a Datasource defined for computer.
Code:
DSN=MyDatasource; UID=MyLogon; Trusted_Connection=Yes; APP=Microsoft Office 2013; WSID=MyComputerName; DATABASE=MySqlServerDB |
#3
|
|||
|
|||
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 |