Message from discussion External data source / MS Query Command Text

Thread-Topic: External data source / MS Query Command Text
thread-index: AcdJgk6aofnIO34HQwmiGw47Pn52eg==
X-WBNR-Posting-Host: 203.41.135.162
From: =?Utf-8?B?QWxsZW5fTg==?= <All...@discussions.microsoft.com>
Subject: External data source / MS Query Command Text
Date: Mon, 5 Feb 2007 16:04:01 -0800
Lines: 20
Message-ID: <BC3922B1-F3CD-4C0B-BDB8-D33BC9898C4C@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2757
Newsgroups: microsoft.public.excel.querydao
NNTP-Posting-Host: tk2msftsbfm01.phx.gbl 10.40.244.148
Path: g2news2.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!t-online.de!keepthis.news.telefonica.de!telefonica.de!news-fra1.dfn.de!news0.de.colt.net!newsfeed.cw.net!cw.net!news-FFM2.ecrc.de!TK2MSFTFEEDS01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGHUB02.phx.gbl

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

Thanks!