Message from discussion External data source / MS Query Command Text

From: Dick Kusleika <dkusle...@gmail.com>
Subject: Re: External data source / MS Query Command Text
Date: Thu, 08 Mar 2007 15:12:51 -0600
Message-ID: <51v0v21ojmp2adhvou9lrgt1m95dcsr5u5@4ax.com>
References: <BC3922B1-F3CD-4C0B-BDB8-D33BC9898C4C@microsoft.com>
X-Newsreader: Forte Agent 4.2/32.1118 trialware
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: microsoft.public.excel.querydao
NNTP-Posting-Host: wsip-68-15-236-171.om.om.cox.net 68.15.236.171
Lines: 1         
Path: g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!news.germany.com!feeder.news.tin.it!207.46.248.126.MISMATCH!TK2MSFTFEEDS01.phx.gbl!TK2MSFTFEEDS02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP06.phx.gbl

On Mon, 5 Feb 2007 16:04:01 -0800, Allen_N
<All...@discussions.microsoft.com> wrote:

>When I Refresh the data source (which is a view in an Access ADP) the columns 
>are returned to my spreadsheet in the wrong order. 
>
>By default, the Command Text window contains simply:
>
>   "Availability"."dbo"."vwShortagesByItem"
>
>I tried changing Command Type to 'SQL' and entering:
>
>   SELECT  ItemNo, Description, Commodity_Group, Nat_Rank, Avg_Cost, 
>   Net_Ordered, Net_Supplied, Net_Shortage, Occurences, Branches, 
>   Customers  FROM  Availability.dbo.vwShortagesByItem
>
>but the columns are returned in the order:
>
>   ItemNo, Commodity_Group, Nat_Rank, Avg_Cost, Net_Ordered, Net_Supplied, 
>   Net_Shortage, Occurences, Branches, Customers, Description
>

Allen:  In Range Properties, uncheck the Preserve Columns check box.
See here

http://www.dailydoseofexcel.com/archives/2004/06/02/add-new-column-to-external-data/

-- 
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com