|
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: Allen_N <All...@discussions.microsoft.com>
Date: Mon, 5 Feb 2007 16:04:01 -0800
Local: Tues 6 Feb 2007 00:04
Subject: External data source / MS Query Command Text
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, Thanks! 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.
| |||||||||||||