I'm just having a heck of a time joining the ACS 2005-2005 data to Census tract shapefiles. I'm using the Summary File Data Retrieval Tool, copying (copy or move feature) the Census "geographic" and "estimates" data to a new spreadsheet, importing into Access 2007, then both converting to Access 2002-2003 and exporting as dBASE. (I'm using ArcGIS 9.2 do have to do this).
I've tried converting the Place of Birth for the Foreign Born into numbers in Excel before importing into Access and also trying to clean the data by pasting and then copying in Word Pad. The best it will do is to display the numbers under Labels in ArcGIS. It won't treat them as numbers in either Symbology or in queries.
Maybe it's how the data is treated in Access? The 2010 Redistricting data works great, but then the Census Bureau has an import tool (into Access) for that.
Thanks in advance!