|
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 |
Newsgroups: microsoft.public.excel.querydao
From: Dick Kusleika <dkusle...@gmail.com>
Date: Thu, 08 Mar 2007 15:12:51 -0600
Local: Thurs 8 Mar 2007 21:12
Subject: Re: External data source / MS Query Command Text
On Mon, 5 Feb 2007 16:04:01 -0800, Allen_N
<All...@discussions.microsoft.com> wrote: Allen: In Range Properties, uncheck the Preserve Columns check box. >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, >but the columns are returned in the order: > ItemNo, Commodity_Group, Nat_Rank, Avg_Cost, Net_Ordered, Net_Supplied, See here http://www.dailydoseofexcel.com/archives/2004/06/02/add-new-column-to... -- You must Sign in before you can post messages.
To post a message, you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| |||||||||||||