Latest Contributions by DougOetter

Bruce- the link is broken.  Do you mind reposting, please? ... View more

We had the same problem, and I didn't find an adequate solution on the forum, but finally got it to work: Select the table you want from the Census Bureau (factfinder.census.gov), at the Block level Unzip the archive file, and Open the .CSV file in Excel Delete the Annotated Header (Row 1) Here's where the problem occurs- Both Excel and ArcMap read the 15-digit GEO.id2 as Double Precision Float, but they BOTH display the numbers in Exponential Format, even though we didn't ask for that.  If you Declare the Format in Excel, it will change back to 15-digit, and that will save in the .XLSX format, but ArcMap will still read it and display it as Exponential.  You can change the Field format (Custom, 0) for the Table Properties, and it will display correctly, BUT since the GEOID10 is a string value, you need to conduct the Join using String.  When you Add Field and use the Field Calculator, the string value still comes in as exponential.  So, instead, Add Field in the feature polygon layer, and use the Field Calculator to put single quotes around the 15-digit string = "'"+GEOID10+"'"  (there is a single quote inside both of those double quotes)\ The new String field looks like this: '130099707022052' In Excel, do the same for the GEO.id2 field using the Text function Concatenate: =CONCATENATE("'",TEXT(B3,0),"'") Export the Excel file to .CSV or tab-delimited .TXT The two string fields will now join Repeat as necessary for additional tables #census #block #attribute #join ... View more