Thanks for the tip. I'll check it out next time I have an issue. For the moment my problem has been resolved by creating the two separate databases. Free is good. We are a small agency and can not justify the expense of SAS software at the moment.

 

Anais Schenk | Planner | AMBAG

Direct 831.264.5088 | Fax 831.883.3755

 

From: ctpp-news-bounces@chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Erlbaum, Nathan (DOT)
Sent: Wednesday, March 09, 2011 9:29 AM
To: ctpp-news@chrispy.net
Subject: [CTPP] RE: Problem Importing CA PL data

 

From a database size issue on solution might be for you to try SQL  server express

 ( http://www.google.com/url?sa=t&source=web&cd=1&ved=0CBwQFjAA&url=http%3A%2F%2Fwww.microsoft.com%2Fexpress%2FDatabase%2F&ei=KLd3Tc36HoKE0QHxtf3fBg&usg=AFQjCNHjeaYABXz3Vpzmoqyz_kqbTWCfuA )

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@chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Anais Schenk
Sent: Wednesday, March 09, 2011 12:06 PM
To: ctpp-news@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@chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Allen, Robert.
Sent: Wednesday, March 09, 2011 7:00 AM
To: 'ctpp-news@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@chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Anais Schenk
Sent: Tuesday, March 08, 2011 5:54 PM
To: ctpp-news@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