The Simple Data Loader wizard, available in ArcCatalog or the Catalog window, allows you to specify a number of source tables and feature classes, provided their schema 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.
- Right-click the table or feature class in the Catalog tree into which you want to load data and click Load > Load Data.
- Click Next on the introductory panel.
- Browse to the input feature class or table.
- Click Add to add the table or feature classes to the list of source data.
- Repeat steps 3 and 4 until you have specified all the source data.
- Click Next.
- Click the first option and skip to step 10 if you do not want to load data into a specific subtype of the target.
- Click the second option if you want to load data into a specific subtype.
- Click the drop-down arrow and click the subtype into which you want to load the source data.
- Click Next.
- Click the Matching Source Field drop-down arrow and click the field from the source data that you want to match to the target field.
- Repeat step 11 until you have matched all the fields you want to load from your source data.
- Click Next.
- Click the first option and skip to step 19 if you want to load all the source data.
- Click the second option if you want to limit the features from the source data that is to be loaded into the target using an attribute query.
- Click Query Builder to open the Query Builder dialog box.
- 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.
- Click OK.
- Click Next.
- 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.
- Click Finish to load your data when you are satisfied with your options.
Leave the Matching Source Field parameter as <None> if you don’t want data from a field in the source data to be loaded into the target data.