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