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

thanks ********************************* Linda J. Johnson C.A.R. Coordinator www.kentucky.com/greenspot page editor Lexington Herald-Leader (859) 231-3338 mailto:ljohnson1@herald-leader.com <mailto:ljohnson1@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@chrispy.net] On Behalf Of Jami Garrison Sent: Thursday, July 14, 2011 4:47 PM To: ctpp-news(a)chrispy.net Subject: RE: [CTPP] RE: Directions on importing Summary File 1 into MS Access The fast and easy way, delete the Access file and download the empty shell again. J From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Johnson, Linda - Lexington Sent: Thursday, July 14, 2011 12:52 PM To: ctpp-news(a)chrispy.net Subject: RE: [CTPP] RE: Directions on importing Summary File 1 into MS Access 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@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@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@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