Importing a table (single)

  1. In the Catalog tree, right-click the geodatabase into which you want to import a table. Click Import > Table (single).

    This opens the Table To Table tool from the Conversion toolbox.

  2. Specify the following parameters for this tool:
    • Input Rows—Specify the input dBASE, INFO, OLE DB, or geodatabase table.
    • Output Location—Enter the location in which the output table will be created.

      This can be either a geodatabase or folder. If the output location is a folder, the output will be a dBASE table.

    • Output Table—Enter the name of the output table.
    • Expression (optional)—Enter the Structured Query Language (SQL) query expression that will be used to select records. The syntax for the expression is different for different data formats. Some of the most commonly encountered differences are below.

      For ArcSDE, the field names are not wrapped, for example, MY_FIELD. For file or personal geodatabases, the field names are wrapped in square brackets, for example, [MY_FIELD]. For all others, the field names are wrapped in double quotes, for example, "MY_FIELD". Access uses * and ? as string wildcards rather than % and _ in all other formats.

    • Field Map (optional)—Choose the fields and field contents from the inputs.

      Each of the unique input fields is listed in the Field Map window, and when expanded, you can see a list of all the input field occurrences (subfields). New fields can also be added.For each field map, you can add, rename, or delete output fields as well as set properties such as data type and merge rule. You can also delete an output field's subfields, and you can format any output field's values if the data type is text.

      Learn more about choosing and setting the output fields

    • Configuration Keyword (optional)—This setting defines the storage parameters (configuration) for file and ArcSDE geodatabases. Personal geodatabases do not use configuration keywords.

      ArcSDE configuration keywords for ArcSDE at the Enterprise level are set up by your database administrator.

      Learn more about configuration keywords

Related Topics