I have had pretty good experience importing Excel files into Arc 10.0, but also primarily use .dbf files.
Reed Sims |
[log in to unmask]"> USDA-NRCS | VT State GIS Specialist | Colchester, VT | (802)
951-6796 x243
Helping People Help the Land | USDA is an equal opportunity
employer and provider
From: Northeast Arc Users Group [mailto:[log in to unmask]]
On Behalf Of Bistrais, Bob
Sent: Friday, August 15, 2014 11:10 AM
To: [log in to unmask]
Subject: Re: Best practices for tabular data?
Just speaking from my own experience, I've had the best luck by importing .dbf files into Arc. Always had issues with Excel, I believe that was an "undocumented
feature" in ArcGIS. CSV files can be quirky, too, and I prefer to avoid them. Why? Because your data may have values with commas (such as "City, State"), which will cause problems with a csv.
My best advice would be to work with the people creating the tabular data and establish standards for your data values and formats. Otherwise your data
will contain a dozen ways of saying the same value.
Sorry, I've never used FileMaker.
BB
From: Northeast Arc Users Group [[log in to unmask]] on behalf of Jennifer M. Kalasardo
[[log in to unmask]]
Sent: Friday, August 15, 2014 10:47 AM
To: [log in to unmask]
Subject: Best practices for tabular data?
Good Morning All,
I’m interested in preferences of ArcGIS users with regards to Excel and Access when organizing raw data to eventually be uploaded. Has anyone used FileMaker with GIS successfully? Preferences
for exporting to either program are welcome too.
Thanks,
Jennifer M. Kalasardo
GIS/CAD Operator
Iroquois Pipeline Operating Company
One Corporate Drive, Suite 600
Shelton, CT 06484-6211
203-925-7224 (W)
203-925-7213 (F)
860-967-9795 (C)
------------------------------------------------------------------------- This list (NEARC-L) is an unmoderated discussion list for
all NEARC Users.
If you no longer wish to receive e-mail from this list, you can remove yourself by going to http://listserv.uconn.edu/nearc-l.html.
------------------------------------------------------------------------- This list (NEARC-L) is an unmoderated discussion list for all NEARC
Users.
If you no longer wish to receive e-mail from this list, you can remove yourself by going to http://listserv.uconn.edu/nearc-l.html.