I have a MS Access Database, with each table containing the data of a particular questionnaire. I am building data entry forms for each of these tables, but as the field names may prove to be confusing for end users to comprehend, I have used the Caption property to specify terms that are much more friendly (these terms are automatically added as labels while building a form).
However, once I have done that, I realized that when I export the tables from MS Access to Excel, the resultant Excel file contains column names that are based off the Caption property instead of the underlying Field Name.
Is there a way that I can use Caption for my forms and the underlying Field Name when exporting tables to Excel?
Thanks!