AnsweredAssumed Answered

Editing Shapefile databases in MS Excel 97-2003

Question asked by DanBear on Dec 5, 2018
Latest reply on Dec 5, 2018 by Dan_Patterson

I do an extensive amount of editing of shapefile databases (.dbf) format for Quality Control with numerous attributes  in MS Excel for compatibility with shapefiles in ArcGIS 10.6.x.    While I clearly see the need for maintaining a high quality end product (shapefile to be used with other applications) this is also frustrating and is leads to a larger amount of time for achieving my end result.

 

I have a number of questions for this subject, but one of them is this:

 

How do I maintain the same order of fields in MS Excel 97-2003 that I have in the .dbf in ArcGIS?

 

As in:

ArcGIS:  a b c d

 

MS Excel:  d b a c

 

Thank you,

 

Mr. Excel

Outcomes