I found the following document on the Census website on using Access to extract data.   Hope it helps.

http://www.census.gov/rdo/pdf/0HowToUseMicrosoftAccessShells.pdf

Thanks.

Regina.

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

Jason,

I used the detailed instructions on the Census’ website for the state-wide, block-level redistricting data and it worked like a charm (surprisingly!)  I’ll see if I can find the link.

Lisa J. Miller

Data/Graphics/GIS Manager

Bi-State Regional Commission

1504 Third Avenue, PO Box 3368

Rock Island, IL  61204-3368

309.793-6302 ext. 133

www.bistateonline.org

Visit our new data portal website for the Greater Quad Cities Region, http://www.GreaterQCRegion.org

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