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