So I have been trying to get this to work all day and have had no success. I am attempting to join a CSV file with a Shapefile. The CSV is from the Hud's location affordability portal (http://www.locationaffordability.info/lai.aspx?url=download.php) and the shapefile is coming from tiger.
I have tried moving the file into microsoft access and converting it to a dbf it tells me that I "cannot define field more than once" and when I do a find replace to in excel it changes the number to scientific notation. I have tried changing the format of the column and leaving it alone in hopes that it would not be effected, but that is not the case.