ACS 5-year data in MS Access by state

Hi all,

This is a duplicate post from the "Using ACS Summary Files" group, but since many may not also be in that group, I thought I'd post this here as well.

As I did with the 2013 ACS 5-Year data, I now have the 2014 ACS 5-year data in MS Access files for a handful of states. Most of these are western states as these are ones I'm directly working with, but if you have a need for the data in Access for a state not here, let me know and I'll prepare the Access file for you.

Querying the data out through Access is helpful to me because I can create a GEOID to quickly link the data into a shape file or Geodatabase, plus I can get any table I need by any geography often quicker than using Fact-finder.

The files are huge, so they are in multiple Access files where you can link to the tables from another Access file or put them into SQL server. So these contain all the estimate and moe tables for each state.

here's where you can get to them:
gisdiva.com/.../

also, let me know if you have any trouble with any of the files.

thanks
Jami

[Updated on 2/11/2016 7:25 PM]
  • Thank you for your Census brilliance, and being so kind to share it!
  • If anyone is interest, I've added the 2011-2015 5-year summary files in MS Access database format here:
    gisdiva.com/.../

    right now there are only 2 states uploaded (Virginia and Arizona) plus the U.S. data, but if you are interested in other states let me know and I can add them.