Add data to an existing table

Adding data to an existing table and editing that data in the table are important parts of maintaining a current and complete GIS. There are several ways to add data to tables.

Copy and paste from another application

You can add data to an existing table by pasting values from other applications such as Microsoft Excel. Copy and paste is a recommended workflow to update and replace existing values with new information. If more rows are pasted than currently exist in the database table's row count, additional rows are automatically created.

Note:

If more columns are pasted than currently exist, additional columns are dropped.

Use geoprocessing to add data

With geoprocessing, you can use tools to update existing fields, append records to a table permanently, or append fields to a table dynamically with a join.

Calculate Field tool

You can use the Calculate Field tool to update existing fields or newly created fields for a feature class, feature layer, or raster catalog. You can calculate numbers, text, or date values into a field. Using code blocks, you can write scripts to perform advanced calculations.

Add Join tool

The Add Join tool links the fields from the join table to a base table.

Typically, you'll join a table of data to a layer based on the value of a field that exists in both tables. The names of the fields do not need to be the same, but the data type does; you join numbers to numbers, strings to strings, and so on.

When you create a joined table, you can use the appended fields in field calculations or for labeling, symbolizing, or querying the data. The fields that are appended from the join table are not permanently attached to the base table. You can undo joins to remove the appended fields.

Join Field tool

The Join Field tool appends the contents from one table to another table based on a common field. You can optionally define which fields from the join table will be added to the input table.

When using this workflow, the fields are permanently added to your base table.

Add Field tool

The Add Field tool adds a new field to your current table or the table of a feature class, feature layer, raster catalog, or raster with an attribute table. Use Calculate Field to populate newly added fields.

Append tool

Use the Append tool to add new features or other data from multiple datasets to an existing dataset. This tool can append point, line, or polygon feature classes, tables, rasters, raster catalogs, annotation feature classes, or dimensions feature classes to an existing dataset of the same type. For example, you can append several tables to an existing table or several rasters to an existing raster dataset, but you cannot append a line feature class to a point feature class.

Add Geometry Attributes tool

The Add Geometry Attribute tool adds new fields and populates them with spatial or geometric characteristics of each feature, such as length, area, or x,y,z coordinates.

Use Fields view to create, modify, and delete fields

Fields view is used to manage the fields associated with a table. In Fields view, you can edit a table's fields and modify field properties, delete fields, or create fields. To open the Fields view, right-click a column heading in the table and click Fields Fields. You can also click Add Field Add Field from the table view's built-in toolbar to directly open the Fields view to add a new field.

Related topics