i need to edit a connection string due to a corporate change in servers.
this change does not allow the query editor(s) to open the query through the
standard Excel defaults.
i'm hoping someone will know a way to edit the connectstring.
thanks!
i need to edit a connection string due to a corporate change in servers.
this change does not allow the query editor(s) to open the query through the
standard Excel defaults.
i'm hoping someone will know a way to edit the connectstring.
thanks!
The QueryTable.Connection property contains the connection string; I have
never tried changing the connection db this way but it should be possible, I
would go into the immediate pane and try this:
? Sheets("SheetName").QueryTables(1).Connection
- to see what the current string looks like
Sheets("SheetName").QueryTables(1).Connection = "... "
To reset the connection parameters
"SteveCarlston" wrote:
> i need to edit a connection string due to a corporate change in servers.
>
> this change does not allow the query editor(s) to open the query through the
> standard Excel defaults.
>
> i'm hoping someone will know a way to edit the connectstring.
>
> thanks!
Thanks,
this did allow me to reconnect. this allowed almost all queries to run
again. the only one that didn't just needed to be relinked.
"K Dales" wrote:
> The QueryTable.Connection property contains the connection string; I have
> never tried changing the connection db this way but it should be possible, I
> would go into the immediate pane and try this:
>
> ? Sheets("SheetName").QueryTables(1).Connection
> - to see what the current string looks like
>
> Sheets("SheetName").QueryTables(1).Connection = "... "
> To reset the connection parameters
>
> "SteveCarlston" wrote:
>
> > i need to edit a connection string due to a corporate change in servers.
> >
> > this change does not allow the query editor(s) to open the query through the
> > standard Excel defaults.
> >
> > i'm hoping someone will know a way to edit the connectstring.
> >
> > thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks