Why are you still using Excel for database ? Import it using MS Access !
Process or filter it and export from Access to Excel.
Still using MSO 2003
Hary
-----Original Message-----
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net]
On Behalf Of Pete Swensson
Sent: Tuesday, August 03, 2010 3:24 PM
To: ctpp-news(a)chrispy.net
Subject: RE: [CTPP] CTPP2006-2008 County-to County work flows are OUT!
Or Excel 2002-2003, which has the same limitation.
Pete Swensson, Senior Planner
Thurston Regional Planning Council
2424 Heritage Ct. SW
Olympia, WA 98502
(360) 741-2530 (direct line)
(360) 956-7575 (main desk)
(360) 956-7815 (fax)
swenssp(a)trpc.org
This e-mail and any attachments are for the use of the addressed individual.
If you have received this e-mail in error, please notify our systems
manager. TRPC has taken responsible precautions to ensure no viruses are
present in this e-mail, however we do not accept responsibility for loss or
damage arising from the use of this e-mail or attachments.
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net]
On Behalf Of Seidensticker, Dan
Sent: Tuesday, August 03, 2010 12:02 PM
To: 'ctpp-news(a)chrispy.net'
Subject: RE: [CTPP] CTPP2006-2008 County-toCounty work flows are OUT!
Tom,
Sounds like you are loading into Excel 2000. It is limited to 65,536 rows.
It loads successfully into Excel 2007 for me.
Dan Seidensticker
GIS Specialist
Madison Area Transportation Planning Board:
A Metropolitan Planning Organization (MPO) City of Madison Planning Unit
121 S. Pinckney Street, Suite 400
Madison, WI 53703
Voice: 608-266-9119
Fax: 608-261-9967
Email: dseidensticker(a)cityofmadison.com
www.MadisonAreaMPO.org
<http://www.madisonareampo.org/>
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net]
On Behalf Of Tom Mank
Sent: Tuesday, August 03, 2010 1:20 PM
To: ctpp-news(a)chrispy.net
Subject: Re: [CTPP] CTPP2006-2008 County-toCounty work flows are OUT!
Liang -
I tried downloading by clicking on the MeansofTransportation_v2.csv
<ftp://ftp.camsys.com/temp/outgoing/CTPP/New%20CTPP%20ACS/MeansofTransportat
ion_v2.csv>
link (3 times) and I get a error message that says 'file not loaded
completely'
When I look at the file it has processed as far as Michigan ...
Tom
Tom Mank
Ithaca-Tompkins County Transportation Council
607-274-5583
>> Liang Long <LLong(a)camsys.com> 7/30/2010
4:58 PM >>>
Hi,
We are pound to announce that CTPP2006-2008 County-toCounty flows using ACS
are available for downloading now! The data file also contains CTPP2000
County-to-county flow for users convenience. Two data formats are
available: SAS and CVS. A detailed note for dataset is also available.
Check it out now!
ftp://ftp.camsys.com/temp/outgoing/CTPP/New%20CTPP%20ACS/
<ftp://ftp.camsys.com/temp/outgoing/CTPP/New%20CTPP%20ACS/>
Liang Long
Cambridge Systematics, Inc.
4800 Hampden Lane
Suite 800
Bethesda, MD 20814
tel 301 347 9141
fax 301 347 0101
FHWA 202-366-6971
e-mail llong(a)camsys.com
www.camsys.com