How do you rename table headers in a query using Offic 07?

[DFoster]

In older versions you could use AS after the field name and replace the name,
now that doesn't work. Example would be select dwdata.lstnme AS "Last".
With this in the query it would bring back a column heading of Last instead
of lstnme.

 

[Duke Carey]

I think you need to wrap the alias in single quotes

 

[DFoster]

It doesn't recognize the AS command anymore

I think you need to wrap the alias in single quotes

 

[Duke Carey]

Are you using MS Query?


I just did this in MS Query with Excel 2007, using this SQL

SELECT Activity.LocationSize, Activity.Function AS 'Fnctn',
Activity.ActivityCount
FROM Activity Activity, location location
WHERE Activity.LocationSize >= location.Lbound AND Activity.LocationSize <=
location.Ubound

It returns the data to Excel with the 2d column's heading being 'Fnctn' -
it unfortunately includes the single quotes in Excel