Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot change column name in Excel's MS Query tool
I am using this 'tool' to review my sql query, in my select statement I am
using this CR.ID, CR.CAT, CR.SEV, substr(cr.pr,1,5), CR.AP, USERS.FULLNAME when get my my result in the MS SQL tool the result shows "substr(cr.pr,1,5)" as a column header, when I move the query to excel the column header is "4" which makes sense as it representing the 4th query. My problem is I want to rename the column header in my result something that I cannot seem to do even using the MS SQL query tool which says I should use this substr(cr.pr,1,5) AS 'PR Number'," Can someone help me with a workaround, I can't seem to use that syntax at all to change the column header in excel when my results are brought back. -- Neall |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I expand formula down a column when query results change? | Excel Discussion (Misc queries) | |||
Excel's camera tool | Excel Discussion (Misc queries) | |||
QUERY: Excel's SaveAs so slow.. | Excel Worksheet Functions | |||
QUERY: Excel's SaveAs so slow.. | Excel Programming | |||
Excel's draw tool to create a Macro Button | Excel Programming |