If you are talking about the *.dbf format Census 2000 files, the trick to
getting them into MS-Access is to import them as Microsoft FoxPro files, NOT
dBase files. At least this worked for me. If you have *.txt files, then you
have to have the column definitions...
------------------------------------------------------------------------
Keith Miller
Principal Planner: GIS and Modeling
North Jersey Transportation Planning Authority, Inc.
One Newark Center, 17th floor
Newark, NJ 07102
973-639-8444
[EMAIL PROTECTED]
Robert Karr wrote:
> Greetings All: Need some help because we're obviously missing something.
>
> We've downloaded the 3 compressed redistricting files for Michigan off the
Census WEB site. They seem to uncompress OK. I only have Excel and
FileMakerPro available on my PC . Excel can't handle that many records, and
truncates at 64k records. Our local FileMakerPro expert tells me FMP just
chokes and errors out, seemingly because of the number of records.
>
> Our Info Sys Division has MS Access, but using the instructions off the
Census WEB site, can't seem to open the files in Access, either. I know if
there was a problem with opening the files in Access there would have been a
great outcry. So, there must be something we don't quite understand,
something very simple and basic.
>
> My database skills are very weak to say the least. I can't figure it out,
but it looks like we're missing something very simple, very basic.
>
> Can anyone out there provide us with an algorithm, advice, things to
check, points to ponder, etc??
>
>
> Please keep up the good work. And, even if I don't get my questions
answered, thank you all for being there.
>
> ....Bob
>
> Robert Karr Phone: 517-373-3028
> Science Research Assistant FAX: 517-373-0171
> Science and Technology Division
> Legislative Service Bureau
> Michigan State Legislatur
> 124
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
