topic Re: lost case number in Data Management Questions

lost case number

mattweber — Thu, 31 Mar 2011 17:51:27 GMT

I am working on a project for the local police department. When I open the excel file in arcgis9.3 all the information is correct. However after the data has been geocoded the police identification number is not there. The only part of the number that remains is the year, however the unique identification numbers have all turned to zeros. I have tried to reformat the cell in arcgis to various number configurations under properties without success. Any suggestions would be greatly appreciated.
matt
wittenberg university

Re: lost case number

JoeBorgione — Thu, 31 Mar 2011 21:26:54 GMT

I am working on a project for the local police department. When I open the excel file in arcgis9.3 all the information is correct. However after the data has been geocoded the police identification number is not there. The only part of the number that remains is the year, however the unique identification numbers have all turned to zeros. I have tried to reformat the cell in arcgis to various number configurations under properties without success. Any suggestions would be greatly appreciated.
matt
wittenberg university

Do youself a favor and import your spread sheet into a table in some flavour of geodatabase and geocode that. Excel is for accountants. Database tables are for analysts. Let the flames begin.

Re: lost case number

AnnaRoberts — Fri, 01 Apr 2011 20:10:24 GMT

Have you tried changing the cell type in Excel, before importing it? Or saving your Excel file as a .csv and importing that instead?

Re: lost case number

mattweber — Sat, 02 Apr 2011 01:22:59 GMT

yes tried that ended up having to go back and reformat excel sheet and create new attribute header. thankyou for the help