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 Rate your overall experience... How was blah, blah... Rate the look of...
John 2 3 1
Sue 1 1 1
...than this...
User A B C
John 2 3 1
Sue 1 1 2
Sorry for lack of formatting, that is supposed to be a 4 column, 3 row spreadsheet.
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.
User Rate your overall experience... How was blah, blah... Rate the look of...
John 2 3 1
Sue 1 1 1
...than this...
User A B C
John 2 3 1
Sue 1 1 2
Sorry for lack of formatting, that is supposed to be a 4 column, 3 row spreadsheet.
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.