[CTPP] RE: Question on 2010 Census data and linking to the Access file

I have had limited luck by following instructions for Access here: http://www2.census.gov/census_2010/01-Redistricting_File--PL_94-171/0FILE_S…. Also found some information here: http://www.cubitplanning.com/blog/2011/02/census-2010-data-via-ftp-american…. Have been able to import two of the three tables and struggling with the third. Kim 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) 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(a)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(a)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 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(a)ovrdc.org