Change field names in query export to Excel

[trishk]

I am trying to output an Access query into an Excel format for a user feedback survey where users rate certain aspects of their experience with numerical values. I would like to export the entire table (within date parameters entered by the user). The problem I am having is that I need the field names on the Excel report to display as the full questions. Currently, the field names are named A, B, C, etc because the full questions exceed alias character limitations. So for example, I would rather my data look like this..

User R

user	How do you rate the overall experience...	Rate the ease of use of the blah blah...	Rate the yada, yada, yada...
John	1	3	2
Sue	2	4	3

...than this...

User	A	B	C
John	1	3	2
Sue	2	4	3

The output must be in Excel because the reports will be distributed to an audience that may want to do their own analysis with the data.

Help please! And thanks in advance.

[trishk]

Sorry for the random floating "User R". Ignore that.

[June7]

I think then your only option is to modify the Excel file after the data is exported.

Can be manual or coded modification.

[trishk]

I was afraid of that. The current process is pasting in the correct column headings once the data is exported to Excel, but my manager would like to eliminate that step.

[meratigoerr]

are your questions saved in another table? You could use a union query to add a row containing the questions. you'd still get the letter column headings, but then at least maybe you'd be able to get the actual questions too.

[trishk]

That might just work! Thanks for the suggestion! I'll try it out and see how it looks.

[June7]

Wow, brilliant, merati!

trishk, are you using TransferSpreadsheet method for the export? I just tested with UNION query and it did work.

[MaleNurse]

With the report in Design View, Right click on the fields and select properties. Select the "Other" Tab and in the Field Name type in the heading you wish to appear on yoru excel report.
That is what I do to one of my reports and it seems to work Ok