The 2025 ACS Data Users Conference will be held on May 29, 2025 (virtual day) and June 3, 2025 (in-person in DC)
American Community Survey Data Users Group
Search for topics, people, or keywords
Sign Up
Log in
Site
Search for topics, people, or keywords
User
Home
Discussion Forum
ACS Resources
Webinars
Conferences
Steering Committee
More
Cancel
Home
Discussion Forum
ACS Resources
Webinars
Conferences
About
More
Cancel
Details
Views
31973 views
Replies
22 replies
Subscribers
541 subscribers
Users
0 members are here
Labels
5 year estimates
access 2007
Summary File
Related Census Bureau Resources
Related Forum Threads
ACS 2013 5-year data available in MS Access 2007
JamiRae
over 9 years ago
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
Dominic
over 9 years ago
Hi everyone,
I'm a database architect with PolicyMap.com - my colleague Elizabeth is a member on this board and pointed me to this discussion.
We load all of the ACS 5 year data into SQL Server every year. We haven't yet downloaded it all because I understand there were some issues with the table shells Excel file (I'm not surprised; I found some myself 2 years ago and reported it to Census). But once we download it all, I then generate SQL Server integration Services packages to import everything into a SQL Server database. This process takes a couple weeks - mostly because I need to determine correct data types for each column (I'm not aware of any documentation on this. Is there any?). We obviously keep all the import packages.
If this sounds like something that can help you, please let me know and I'll see what we can do to help out.
Cancel
Up
0
Down
Reply
Cancel
Reply
Dominic
over 9 years ago
Hi everyone,
I'm a database architect with PolicyMap.com - my colleague Elizabeth is a member on this board and pointed me to this discussion.
We load all of the ACS 5 year data into SQL Server every year. We haven't yet downloaded it all because I understand there were some issues with the table shells Excel file (I'm not surprised; I found some myself 2 years ago and reported it to Census). But once we download it all, I then generate SQL Server integration Services packages to import everything into a SQL Server database. This process takes a couple weeks - mostly because I need to determine correct data types for each column (I'm not aware of any documentation on this. Is there any?). We obviously keep all the import packages.
If this sounds like something that can help you, please let me know and I'll see what we can do to help out.
Cancel
Up
0
Down
Reply
Cancel
Children
No Data