How to Alter Field Names Upon Exporting to Excel

D

Delnang

All,
When I export to Excel, the column headings read like:
Column A Job_Title (my:myFields/my:position/my:Job_Title)

Column B Job_Code (my:myFields/my:position/my:Job_Code)

Column C This field requires a valid date format (i.e. 8/1/04)
(my:myFields/my:position/my:Last_Revised_Date)

I just want simple headings such as: Job Title, Job Code and Last Revised
Date.

How do I get rid of all the (my:myfields/my....

Thanks,
Angie
 
B

Brian Teutsch [MSFT]

I don't believe this is possible. InfoPath will use the full name of the
field to ensure a unique field name.

Brian
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Control Export to Excel 0
Exporting to Excel 0
exporting report fields to spreadsheet 1
export outlook task to excel 0
Can I export from Access to Excel using field names not captions? 0
Automated Export to Excel on Several *.xml Files 1
Transfer data from user form to register spreadsheet 0
Exporting SQL Server Data to Excel through InfoPath 0

Top