Solved Custom column names on export to excel?

[mamradzelvy]

Hi, is it possible to have my query pull data from the db and put it under new custom column names for the excel export?
I have a db with shortcuts which are not exactly pleasant to look at by anybody but me and i would like to be able to export these under diferent names without actually hard modifying the column names in the table.

 

[arnelgp]

create a Query and Alias the Column into something else.
import this query to excel, eg:

SELECT ID AS Ident, ProdID AS ItemCode, UnitPrice AS Price, etc.... FROM table1

 

[deletedT]

In Excel If you're using a Pivot table, you can change the field name: