Exporting to Excel..Custom Column Name

[Superock]

When you export a qry to Excel, is there a way to make the Column heading the same as your caption.

When I export now I get colum heading

FirstName, Lastname where I would like to have
First Name, Last Name

 

[fpendino]

You can change what's being outputted from within the query. In SQL view it would look like this.


SELECT tblEmp.FName AS [First Name], tblEmp.LName AS [Last Name]
FROM tblEmp;

Notice that it's selecting the field by it's original name then it has 'as whatever' following.