I have an Excel Spreadsheet that is being updated daily and would like to map that spreadsheet to a feature class. The spreadsheet has an ID field in it (#09-09, etc.) . . . but can I create an ID field in the Feature Class table to Join with or will the data types prevent me from doing that?
You can add a field to your table to match and in Pro, there is even a field calculator autoincrement ..
You can even snag the field calculator code here.
in the ...
Accumulative and sequential calculations
I guess another way to ask the question I have is.
Is there a way to populate an attribute table with records from an Excel Spreadsheet which doesn't have a Lat and Long field through the Field Calculator