I have Excel and Access 2007 and OpenOffice

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)
Fax: 740-947-3468
www.ovrdc.org
Email: jgillow@ovrdc.org

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

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

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