AnsweredAssumed Answered

ArcGIS Pro and Excel Table Problems

Question asked by BrianK on Dec 1, 2016
Latest reply on Dec 21, 2016 by BrianK

I'm having too many quirky things happening with the use of ArcGIS Pro 1.3.   Lets take my recent problems with tables.   If I use the geoprocessing tool to export a Feature Class table to Excel.  Access cannot read it.  I have to open it in Excel and then save it as an Excel file and then import it into Access.

 

But even worse, I have a file that has a field called InvestigationID in an Excel file.  It is a unique ID.  When I open up the Excel file in ArcGIS Pro, the entire column of InvestigationID is converted a single 10 digit number.  The original IDs are 10 digit also.  Not only does the table in Pro have this converted value, the original Excel table of unique IDs is converted to this single ID.  This is horrible and I'm not going to spend my time trying to find out exactly where this went wrong.  I was starting to like Pro but cannot trust it anymore.   Time to return to ArcMap. 

Outcomes