I have had limited luck by following instructions for Access here: http://www2.census.gov/census_2010/01-Redistricting_File--PL_94-171/0FILE_STRUCTURE.pdf.  Also found some information here:  http://www.cubitplanning.com/blog/2011/02/census-2010-data-via-ftp-american-fact-finder-2-help/.  Have been able to import two of the three tables and struggling with the third.
Kim Anderson
Associate Regional Planner
San Joaquin Council of Governments

555 East Weber Avenue
Stockton, CA 95202
209-235-0565 (Direct)
209-235-0600 (Main)
209-235-0468 (Fax)

>>> "Graham, Todd" <todd.graham@metc.state.mn.us> 05/12/2011 10:51 AM >>>

Do you have SAS in your shop?


I can provide you my SAS code for loading, compiling and merging the Redistricting, the AGQ, and the DPSF.


Can’t offer any help on the Access.  Good luck.


Todd Graham
Principal Forecaster and Project Manager
Metropolitan Council
390 Robert Street North
Saint Paul, MN 55101
ph:  651/602-1322
email:  todd.graham@metc.state.mn.us
web:  http://www.metrocouncil.org/data/


From: ctpp-news-bounces@chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Jason Gillow
Sent: Thursday, May 12, 2011 12:07 PM
To: ctpp-news@chrispy.net
Subject: [CTPP] Question on 2010 Census data and linking to the Access file


Hello all


I was wondering if anyone had a chance to figure out how to import the 2010 Redistricting data or the new 2010 demographic profile information into the Access files on the http://www2.census.gov/census_2010/ , under http://www2.census.gov/census_2010/01-Redistricting_File--PL_94-171/ and http://www2.census.gov/census_2010/03-Demographic_Profile/ . I have been confused about this process myself. Does anyone know of any good guides to help? Any ideas or suggestions?  I have been using the new American FactFinder 2 too, but that has been a slow and confusing process too.


Thank you




Jason Gillow
Research/Planning Specialist II
Ohio Valley Regional Development Commission
9329 St Rt 220 E, Suite A
Waverly, OH 45690
Phone 740-947-2853 or 800-223-7491 (In Ohio)
and Fax 740-947-3468
Website: www.ovrdc.org
E-mail- jgillow@ovrdc.org