ArcGIS Server Banner

Loading data in ArcCatalog

Loading data in ArcCatalog

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback

About loading data in ArcCatalog

Note: This topic was updated for 9.3.1.

The Simple Data Loader wizard in ArcCatalog allows you to specify a number of source tables and feature classes, provided their schemas match. It also allows you to specify which fields in the input data are loaded into which fields of the target feature class or table.

The wizard also gives you the option of loading all the source data into a subtype of the target and lets you specify a query to limit the features you load.

How to load data in ArcCatalog

  1. Right-click the table or feature class in the Catalog tree into which you want to load data, point to Load, and click Load Data.
  2. Click Next on the introductory panel.
  3. Browse to the input feature class or table.
  4. Click Add to add the table or feature classes to the list of source data.
  5. Repeat steps 3 and 4 until you have specified all the source data.
  6. Click Next.
  7. Click the first option and skip to step 10 if you do not want to load data into a specific subtype of the target.
  8. Click the second option if you want to load data into a specific subtype.
  9. Click the drop-down arrow and click the subtype into which you want to load the source data.
  10. Click Next.
  11. Click the drop-down arrow in the Matching Source Field list and click the field from the source data that you want to match to the target field.
  12. Leave the Matching Source Field as <None> if you don’t want data from a field in the source data to be loaded into the target data.

  13. Repeat step 11 until you have matched all the fields you want to load from your source data.
  14. Click Next.
  15. Click the first option and skip to step 19 if you want to load all the source data.
  16. Click the second option if you want to limit the features from the source data loaded into the target using an attribute query.
  17. Click Query Builder to open the Query Builder dialog box.
  18. Use the Query Builder to create a query to limit the features or rows from the source data that are going to be loaded into the target.
  19. Click OK.
  20. Click Next.
  21. Review the options you have specified for loading your data. If you want to change something, you can go back through the wizard by clicking Back.
  22. Click Finish to load your data when satisfied with your options.

Tips

  • When matching fields, you can browse the source data’s field values to help you correctly match the source and target fields.
  • The Simple Data Loader can't be used with some types of nonsimple feature classes, including
    • Network feature classes
    • Feature classes with feature-linked annotation
    • Feature classes or tables in a relationship class with message notification set to Both
    • Origin feature classes or tables in a relationship class with message notification set to Forward
    • Destination feature classes or tables in a relationship class with message notification set to Backwards
    • Origin feature classes in composite relationships

    To load data into these types of feature classes, use the Object Loader.

See Also

  • About loading data into existing feature classes and tables
  • Work flow strategies for loading data
  • Loading data in ArcMap