Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

New to GIS and Ive been trying to figure this out for a while. I have an excel sheet with CT names such as 0128.03, 0128.04, starting from 0001.00 and up. Not all CTs have .01, .02 at the end just .00. anyways when I transfer it to a dbf and open it up in arc the field shows with no decimals. I did a custom format for 0000.00 but for some reason 0128.03 shows up twice and I was missing 0128.04. I realized the duplicate of 0128.03 actually was 0128.03999999 and should be 0128.04 theres others doing the same thing as well. I have no clue how to get 128.04 or stop the continous decimal. Do I format the cells a certain way in Excel? I need these values to be correct so i can join the CT field with another table.

share|improve this question
2  
instead of saving to a dbf, try saving to a 97-2003 .xls file. –  gm70560 May 24 '13 at 17:12
    
I saved it as a .xls first then export from arc as DBF. and CT is the field head and the numbers are the values –  user18492 May 24 '13 at 17:22
2  
You might find my explanation at quantdec.com/SYSEN597/GTKAV/section4/chapter_15a.htm#Recipe to be helpful. –  whuber May 24 '13 at 17:23
    
Wouldn't you be better off is exporting the data as a CSV then in ArcGIS export that file to a DBF? Meanwhile, do a table join by CT_ID for the whole layer and then export the joined layer as its own layer? –  dassouki May 24 '13 at 19:12

2 Answers 2

Try saving as CSV and see all the answers and comments on How to best prepare csv files for use in arcgis. Once it is imported into ArcGIS you can export/convert to dbf or gdb or other table format.

share|improve this answer

you might try formatting the column as text, which will be necessary to preserve the leading 0s.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.