| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rename column header after filtering column results in the MS SQL
I am using the MS SQL tool in excel and I have a filter on a column that I
only want the first 5 digets in the column to return, that works... However I need to rename the column header and the MS SQL tool does not seem to like or let me do it, know I am using the correct SQL Syntax AS 'column header' but when I try to do it I get an error Can someone help Tthanks -- Neall |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
rename column header after filtering column results in the MS SQL
Neall: this sounds very similar to an issue I was experiencing and found
this Microsoft Support article to be the answer. http://support.microsoft.com/kb/259347 I hope this helps you as well. Good luck! Dale "Neall" wrote: I am using the MS SQL tool in excel and I have a filter on a column that I only want the first 5 digets in the column to return, that works... However I need to rename the column header and the MS SQL tool does not seem to like or let me do it, know I am using the correct SQL Syntax AS 'column header' but when I try to do it I get an error Can someone help Tthanks -- Neall |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating column A * column B = Results in another column | Excel Worksheet Functions | |||
| rename column header | Excel Discussion (Misc queries) | |||
| Return column number from column header text | Excel Discussion (Misc queries) | |||
| Search for a column based on the column header and then past data from it to another column in another workbook | Excel Programming | |||
| Replace all non blanks in a column with column header | Excel Discussion (Misc queries) | |||
Linear Mode
