[CTPP] RE: Problem Importing CA PL data

( http://www.google.com/url?sa=t&source=web&cd=1&ved=0CBwQFjAA&am… ) it may be a chore, but it is free and you can spend endless hours loving Microsoft. It will let you get the files in, since the size limit is MS Access is not the issue and then you can access them by MS access. It may be a steep learning curve for you but it is another option and it works because its free. Your other option is SAS or SPSS or maybe R or simply wait until someone else does it for you. In any event what we have here a situation where the total lack of serious though leadership on the part of the Census Bureau would have resolved hundreds of hours of efforts on the part of many to do what the CB could have provided for in advance. But then what can we expect, they're from the government and they're here to help you, I believe that is how the expression goes....... From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Anais Schenk Sent: Wednesday, March 09, 2011 12:06 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] RE: Problem Importing CA PL data Thank you Robert. It turns out the files are massive and that appears to be the problem. No matter which order I import in, Access can't import the third file. I've adopted your method and I've created two Access databases, one for the first PL data table and another for the second table. I was able to import the geo table into both and can query the data for our region's counties for use in GIS. Thank you for saving me from a lot more frustration. Anais Schenk | Planner | AMBAG Direct 831.264.5088 | Fax 831.883.3755 ________________________________ From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Allen, Robert. Sent: Wednesday, March 09, 2011 7:00 AM To: 'ctpp-news(a)chrispy.net' Subject: [CTPP] RE: Problem Importing CA PL data What size files are getting in Access when you try to import the files? In Texas, the files were too big to import all three at once into Access. Access has a code limited total data file size of 2 GB. I could import two of the files in any sequence and Access would always choke on the third, saying that the file was unrecognized or corrupt, but the actual problem was that the 2 GB limitation was being exceeded. Using a 64-bit version did not help as the 2 GB is a Microsoft Access program code limit, not a computing power limit. I finally had to hook the geoheaders up to the two data files in two steps, then cut down the resulting databases into substate areas that could be handled within the coding limitations of Access and Excel before hooking the data up to the census geography files in our GIS system. Robert R. Allen, AICP Abilene MPO 400 Oak St. #102, Abilene, TX 79602 Phone 325-676-6243 Fax 325-676-6398 From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Anais Schenk Sent: Tuesday, March 08, 2011 5:54 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] Problem Importing CA PL data Has anyone else had a problem importing the "cageo2010" file into Access 2003? I keep getting an error message saying that access doesn't recognize or find the database. I followed the instructions in the "0File_Structure" pdf exactly. I got the other two tables imported just fine, but can't seem to get the geo table. Anais Schenk | Planner Direct 831.264.5088 | Fax 831.883.3755 [cid:image001.jpg@01CBDE55.8687BC20]