[CTPP] RE: processing redistricting files in Access---more

In using Access 2007 I find that when importing the spec file for part 2 it truncates the columns and fails to import the three housing fields. Anybody else experience this? Clearly building a second spec file that skips all of the P columns and just imports the H columns will get around it, but I was a little surprised that it didn't work, unless there are too many columns already? It also appears that the spec file has some issues in the geo file as well as some of the fields towards the end of the list are incorrectly being processed or their field width is incorrect ---------------------------------------------------------- Nathan Erlbaum Associate Transportation Analyst Office of Policy, Planning & Performance New York State Department of Transportation 50 Wolf Road, 6th Floor Albany, New York 12232 (Tel) 518.457.2967 (Fax) 518.457.4944 (E-mail) nerlbaum(a)dot.state.ny.us (Web) www.nysdot.gov -----Original Message----- From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Harun Rashid Sent: Tuesday, March 22, 2011 8:47 AM To: ctpp-news(a)chrispy.net Subject: [CTPP] RE: processing redistricting files in Access Todd A. Steiss yesterday posted this - www.census.gov/rdo/pdf/0HowToUseMicrosoftAccessShells.pdf A very detailed, step-by-step (with screen-shots) set of instructions to work with Access shells provided by Census. An excellent resource to aid Mara Kaminowitz's original work-flow steps. Harun Harun Rashid, AICP Senior GIS Planner BCD Council of Governments 1362 McMillan Avenue, Suite 100 North Charleston, SC 29405 T: 843.529.0400 F: 843.529.0305 www.bcdcog.org _______________________________________________ ctpp-news mailing list ctpp-news(a)chrispy.net http://www.chrispy.net/mailman/listinfo/ctpp-news