I have a File Geodatabase from an external source that has a number of layers. I need to crosswalk this data to our own data model so some or part of it can be imported into our own database.
To do this, I want to first create a "field map" in Excel that has a separate tab for each of their layer attribute tables that lists their field name, the field data type (long, text, double, etc.), and the field length. I will then add a column and use that to populate which of our own fields are most equivalent for each one (if any).
This would be much faster if there was a way to export just the field names and their properties for each layer from ArcMap as a table - does anyone know if that's possible?
Right now I'm just exporting one data record for each table, opening that in Excel, then copying the field names row and pasting it as a "transpose" to turn it into a vertical list. I then would have to look up each field one-by-one in the layer properties window and manually enter in the field type and length for each one. There will probably be well over 100 fields though, so this is going to be a pain doing it that way.