The 2025 ACS Data Users Conference will be held on May 29, 2025 (virtual day) and June 3, 2025 (in-person in DC)
Details
  • Views 2590 views
  • Replies 3 replies
  • Subscribers 541 subscribers
  • Users 0 members are here
Labels
Related Census Bureau Resources
Related Forum Threads

Importing 2012 5yr geography file into Access

Hans Yoo
over 10 years ago
Does anybody have advice or experience importing the geography file for the 2012 5-yr ACS data into Access 2007? I'm having trouble parsing out the correct fields.

Any advice would be much appreciated.

Thanks!
Parents
  • over 10 years ago
    If you navigate to the User Tools folder you can find the 2012_Summary_FileTemplates.zip file referenced by Marta.

    I was able to track down the file and discovered that it is an excel file that contains only the field names and field aliases. However, I imported the text file following the field size and position using the Tech Doc (pg. 10-12) to create the geography file in the structure that I needed.

    Thanks for the lead!
Reply
  • over 10 years ago
    If you navigate to the User Tools folder you can find the 2012_Summary_FileTemplates.zip file referenced by Marta.

    I was able to track down the file and discovered that it is an excel file that contains only the field names and field aliases. However, I imported the text file following the field size and position using the Tech Doc (pg. 10-12) to create the geography file in the structure that I needed.

    Thanks for the lead!
Children
No Data
For more information about the American Community Survey Census Bureau Website