Re: Re-pointing Excel ODBC query to different system

[kirkg@xxxxxxxxxxxxx]

Looks like MSQuery in Excel doesn't create or at least doesn't leeave 
behind and .dqy files 
_____________________
Kirk Goins
Systems Engineer, Manage Inc.
IBM Certified iSeries Solutions Expert
IBM Certified iSeries e-Business Infrastructure
IBM Certified Designing IBM e-business Solutions 
Office 503-353-1721 x106 Cell 503-577-9519
kirkg@xxxxxxxxxxxxx      www.manageinc.com




"Chris Devous" <cdevous@xxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
02/26/2003 03:32 PM
Please respond to Midrange Systems Technical Discussion

 
        To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
        cc: 
        Subject:        Re: Re-pointing Excel ODBC query to different system


Open the .dqy file in MSQuery, click on file/table definition, and change 
the data 
source to one that points to the system you want.  If lib/file are the 
same on the target 
system, you should be OK.

--Chris

On 26 Feb 2003 at 14:45, Bill wrote:

> 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
> 
> My experience echoes yours, you can't point a query to another system
> - I assume because the data source "hard points" to the original
> system. Libraries can be changed though.
> 
> Here are some options:
> If you know how, you can change the Connection Property of the
> QueryTable. The DSN= is part of the connect string.  It's easy to do
> if you know how to manipulate the spreadsheet objects in the
> VisualBasicApps language.
> 
> Select the SQL button on the Query (if you used the MSQuery interface
> to define the query) and select and copy all of the statement.  Cancel
> back and on a new sheet create an external data query.  Select the new
> data source.  Cancel out of the table select.  Select the SQL button
> and paste the statement you copied earlier.  Change the system name
> portion of the "From" statement(s) and library name if necessary.
> 
> Bill
> 
> 


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.