Re: Re-pointing Excel ODBC query to different system -- MIDRANGE-L

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.

Subject: Re: Re-pointing Excel ODBC query to different system
From: "Chris Devous" <cdevous@xxxxxxxxxxx>
Date: Wed, 26 Feb 2003 14:37:54 -0700
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>,<mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>,<mailto:midrange-l-request@midrange.com?subject=unsubscribe>
Priority: normal

Did you save your query as an MS query object?  If so, you should be able to 
bring it 
up independently of Excel and change the connection name.

--Chris

On 26 Feb 2003 at 12:53, kirkg@xxxxxxxxxxxxx wrote:

>  I created an excel book that has 4 sheets, each sheet uses a ODBC MS
> Query to pull a subset of data from the same file. Now I'm done
> testing how can I get Excel to point to a Different System?
> 
>  The only way I can see is via an new worksheet/data/get ext data/new
>  db 
> query which means I have to re-create the worksheet from scratch
>

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

iChat on Feb 27 , jt

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.