ACS 2013 5-year data available in MS Access 2007

Hi all,

I will be importing the 5year estimate summary files for Oregon, Arizona, and Washington D.C. into an Access database (2007 version). I've set up a macro to run the import routine so it wouldn't be too difficult to do additional states. The files are large so, as you can imagine, it actually takes multiple Access files to import them all. Ideally these should be used on a SQL server, though I currently don't have access to SQL so this is my method for now.

If anyone would like the Access files for any state, let me know and I can import it for you or send you documentation on how to do it for yourself. I will need to test my import routine when the data are released on Thursday so I don't want to give out the documentation files until I know this works properly. I did this for the 2012 5year estimates, so I know it works, but I've had to make adjustments due to changes in the Sequence Files so I want to make sure I got the adjustments correct before I distribute it.
Parents
  • Hi All,

    I've started creating the state files in MS Access 2007. I have some documentation but will be creating more detailed documentation on how to use the files over the next week. For now there is some basic documentation to get started. If you understand Summary Levels, how to find the sequence file for the table you want, and how to query in Access you should be fine with what I've got so far.

    As of now the following states are available:
    Arizona, Maryland, Oregon, Virginia, and District of Columbia (Wash D.C.)

    I'll be adding more each day until I get them all done.

    Get the files here:
    gisdiva.com/.../

    If you use these files and find any errors, please let me know so I can fix them. thanks!

    [Updated on 12/5/2014 9:30 AM]
Reply
  • Hi All,

    I've started creating the state files in MS Access 2007. I have some documentation but will be creating more detailed documentation on how to use the files over the next week. For now there is some basic documentation to get started. If you understand Summary Levels, how to find the sequence file for the table you want, and how to query in Access you should be fine with what I've got so far.

    As of now the following states are available:
    Arizona, Maryland, Oregon, Virginia, and District of Columbia (Wash D.C.)

    I'll be adding more each day until I get them all done.

    Get the files here:
    gisdiva.com/.../

    If you use these files and find any errors, please let me know so I can fix them. thanks!

    [Updated on 12/5/2014 9:30 AM]
Children
No Data