CODEWITHSUNDEEP
excelconnection-stringexcel-2013excel-external-data
user3165854
user3165854

Reputation: 1655

Change connection to external data source

I have an Excel 2013 file which shows data from an external DB2 database. The DB2 database has moved and I would like to change connection information to point to the new IP of the database.

How do I do this in Excel?

At the moment the only way I can find to do this is by creating a new connection and adding all of the views against that it is calling instead of just editing an IP address.

Upvotes: 1

Views: 6079

Answers (1)

WhiteHat
WhiteHat

Reputation: 61222

should be simple enough, you just need to update the connection string

Go to...

Data --> Connections

There you should see a list of the connections used in the spreadsheet.
Select the connection(s), then click --> Properties.

On the Connection Properties dialog, you should see two tabs, select --> Definition.

You should find the information in the text area for --> Connection String

Change it and save it...

========================================================

To find connections made through ODBC connections...

Control Panel --> Administrative Tools --> ODBC

Look thru the tabs for User DSN -- System DSN -- File DSN...

Find the Data Source name found in the Connection String.

Select and click --> Configure.

Upvotes: 2

Related Questions