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