New subject: [CTPP] RE: Directions on importing Summary File 1 into MS Access

14 Jul 2011

If someone has Access experience can help, I would love to know how to
delete all the HI records from three tables I imported for testing
purposes of the great Access instructions.

I need to get the data out of there before KY's comes out and I don't
use Access much.

Thanks

Linda J.

*********************************

Linda J. Johnson

C.A.R. Coordinator

www.kentucky.com/greenspot page editor

Lexington Herald-Leader

(859) 231-3338

mailto:ljohnson1(a)herald-leader.com <mailto:ljohnson1(a)herald-leader.com> 

*********************************

In the interests of the environment, please do not print out this email.

From: ctpp-news-bounces(a)chrispy.net
[mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of
JClark(a)bellevuewa.gov
Sent: Thursday, July 14, 2011 12:29 PM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] RE: Directions on importing Summary File 1 into MS
Access 

Hi  I did the  MS ACCESS Directions and it worked and was easy.

I did the HI example (except I chose a different table than the example)
and I guess with interruptions it still was fairly brief; e.g. less than
half hour.

Judy Clark 
Modeling and Forecasting Manager 
City of Bellevue 
(425) 452-7858 
www.bellevuewa.gov <http://www.bellevuewa.gov> 

From: ctpp-news-bounces(a)chrispy.net
[mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of
Elaine.Murakami(a)dot.gov
Sent: Wednesday, July 13, 2011 9:51 AM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] Directions on importing Summary File 1 into MS Access 

Would anyone like to volunteer to test out these directions and then
report back to the CTPP listserv on how well it worked? 

http://www2.census.gov/census_2010/04-Summary_File_1/0HowToUseMSAccessWi
thSummaryFile1.pdf 

Sometimes when I send an email, the link gets broken.  The full link
ends in "....pdf" 

In the meantime, I am testing out the data access system at the Missouri

data extractor (Dexter/uexplore) to look at Summary File 1.  It is
pretty easy, so far. 

http://mcdc.missouri.edu/cgi-bin/uexplore?/pub/data/sf12010   

   on this page, select the FIRST LINE "Datasets.html"   then I selected
Colorado. 

    I chose counties  in Denver 08031  using the FILTER (first set of
boxes) and selected "tracts"  and then I selected Table H 12 and got a
comma-delimited file, which I read into excel.   You have to select BOTH
the geography fields in the LEFT box as well as the table (variable)
fields in the RIGHT box.   If you forget to select the geography fields,
you will get the table variables without any corresponding geography,
which is not very useful. Ask me how I know. J

Finally, I thought that when the Census released the Summary File 1
files on the ftp site that it meant the data would also be in AFF2, but
apparently this is not true.  There are "quick tables" in AFF2, and
these may satisfy your needs, but it is not the full set.  

Elaine Murakami

FHWA Office of Planning

206-220-4460 

RE: [CTPP] RE: Directions on importing Summary File 1 into MS Access