I am trying to create Excel Spreadsheets from Queries so the end user can manipulate the data easier.
I am able to Export the Query to Excel using TransferSpreadsheet. My problem is when I open the spreadsheet the columns that pull information from lookup tables show the number instead of the name.
For example I have a table of sales people names that feed the field SalesPerson in another table. The field SalesPerson it shows the names you can choose from and hides the corresponding record number. When I run the query the name will show in the query results but when export the query to excel using transfer spreadsheet, only the corresponding number shows and not the name.
Any help would be greatly appreciated! Thanks!