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!

Mara Kaminowitz over 10 years ago

I think there is a csv option. But if you want the geography file headers you need to first pull them in to the geography template at www2.census.gov/.../2012_Summary_FileTemplates.zip.
Cancel
Up 0 Down

Reply

Cancel
Oleh Wolowyna over 10 years ago

Marta, this link gives: "was not found on this server".

oleh wolowyna
Cancel
Up 0 Down

Reply

Cancel
Hans Yoo 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!
Cancel
Up 0 Down

Reply

Cancel