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 2703 views
  • Replies 2 replies
  • Subscribers 540 subscribers
  • Users 0 members are here
Labels
Related Census Bureau Resources
Related Forum Threads

Importing the geography file into Access 2007

Hans Yoo
over 10 years ago
Does anybody have advice or experience importing the 5yr 2012 ACS geography file into an Access 2007 database? I'm running into problems where the fields aren't matching up in the same way as the 2010 5-yr geography file did.

Any thoughts / advice is much appreciated.

Thanks!
Parents
  • over 10 years ago
    Did you find a solution to your problem? I suspect the issue is the multiple-coding of goegraphies that started with the 2012 multi-year ACS... To avoid disclosure problems the Census Bureau kept the 2000 Census PUMA (puma00) on the file for surveys collected in earlier years and added the new 2010 Census PUMAs (puma10) on the file for surveys collected in 2012...
Reply
  • over 10 years ago
    Did you find a solution to your problem? I suspect the issue is the multiple-coding of goegraphies that started with the 2012 multi-year ACS... To avoid disclosure problems the Census Bureau kept the 2000 Census PUMA (puma00) on the file for surveys collected in earlier years and added the new 2010 Census PUMAs (puma10) on the file for surveys collected in 2012...
Children
No Data
For more information about the American Community Survey Census Bureau Website