rename column header after filtering column results in the MS SQL

[Guest]

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

 

[Dale]

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