Would someone assist with how I can export data from two or more related tables to excel in such a way that the field names do not show the source table names.
Do you just need the data or do you need a different name.
If you export as a Merge only the field name shows int he header down and not the table name. You will likely need to manually change .mer to .csv unless the export is scripted.
I need the data and export is not scripted
I had the same problem and found the solution here: Export to Excel and Keep Field Labels I went for the temporary table option.
- use an XML export and use an XSLT to transform the data into the proper XLSX format
- post-process the export with an OS scripting language script to rewrite the first row
Retrieving data ...