I have a db that exports a file as an Excel. I want users to be able to make changes to that excel and then re-import it.
I am running into a problem, I want users to see the Logical Names (Captions) so that they can see names they will recognize. But when I try to import the sheet without headings, I get an Field 'F1' doesn't exist error. My research points ot the problem being that there are no headings...
So i wondered if there is a way to export the captions and the field names.
Or is there some other option I haven;t thought of?
Thanks