Print

Print


I have had pretty good experience importing Excel files into Arc 10.0, but also primarily use .dbf files.


Reed Sims | [cid:[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)
[log in to unmask]<mailto:[log in to unmask]>

------------------------------------------------------------------------- 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.




This electronic message contains information generated by the USDA solely for the intended recipients. Any unauthorized interception of this message or the use or disclosure of the information it contains may violate the law and subject the violator to civil or criminal penalties. If you believe you have received this message in error, please notify the sender and delete the email immediately.

------------------------------------------------------------------------- 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.