Whether it is a .dbf from a Shapefile or a PC ArcInfo Coverage, an info file from an ArcInfo coverage, or a MS Access table, creating and editing tables is an intricate part of the day to day tasks in GIS.
Tables can be manipulated in ArcMap, ArcCatalog, and through the ArcToolbox in ArcGIS. How the tables are accessed and edited will depend on the needs of the task to be accomplished and the preferences of the technician.
Here are a few tips that will make working with tables in ArcGIS a little easier:
* Some characters in field or table names are not supported.
o Names must not have a space.
o Names must not have a hyphen. (Example x-coord)
o Names must not have brackets.
o Names must not have special characters. (# * / ~)
o Names must not start with a number or underscore.
* Field names in delimited text files must be edited to remove these unsupported characters before using them.
* Tables that contain Memo fields cannot be accessed in ArcGIS.
* Field and table names can be 31 characters for Geodatabase feature classes.
* A dBASE field name can be up to 10 characters long.
* A dBASE table name has no limit to the length.
* Up to 16 letters or numbers can be used in coverage field and table names.