ArcGIS Pro 3.2.1
I have an Excel .XLSX spreadsheet that I want to use in ArcGIS Pro:
When I navigate to the spreadsheet in Catalog and open the Fields view, I see that ArcGIS Pro has guessed at the datatypes.
Those datatypes aren't quite right. The integer fields have been interpreted as doubles.
I want to change the interpreted datatypes from double to integer for clean data analysis and join purposes. But if I understand correctly, that doesn't seem to be possible without doing something like the following:
- Import the table to a geodatabase
- Rename the fields to ..._OLD
- Create new fields with the correct datatype
- Populate new fields via a field calculation
- Delete the ..._OLD fields.
That's not ideal.
- Too much effort.
- Now I'm using a copy of the data instead of the refreshable Excel data.
It's my guess that the Excel data has been copied into memory or into an FGDB somewhere (that's why we're able to do things like use SQLite SQL on Excel files). If that's the case, could we have the option of setting/overriding the field datatypes? Maybe it would be as simple as making the Fields View editable instead of read-only.