Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel data connection
Hi all,
I have a question relating to the Excel office data connections in Excel 2007. I have a file which contains numerous embedded connections pointing to various sheets which create table/pivot table structures. I am using this file in an application which refreshes the data and then uses the new data to create various outputs. The question i have surrounds the ability to change the connection string. I can set the command text via my application and change this as required. The problem i have is if i want to point the sources to another server. Is there any way that i can set up a connection sting in my app.config file and use this to change the connection string at runtime? my app is a .Net application using C#. Any help on this would be much appreciated as i'm having absolutely no luck. Thanks in advance, G |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 data connection | Excel Discussion (Misc queries) | |||
Data Connection from Excel to Access | Excel Programming | |||
Excel data connection to Access | Excel Discussion (Misc queries) | |||
always recheck data connection library for latest connection strin | Excel Discussion (Misc queries) | |||
Excel ODBC Data Connection | Excel Programming |