To Import from Excel

To import data from Excel into an industry model

  1. Open the Excel file and select the columns and rows to import.

    The corresponding field names must be in the first row of the selected area.

  2. Navigate to the directory where you will save your data.
  3. In the Maintenance workspace in AutoCAD Map 3D toolset, in the Industry Model explorer, select the feature class to update.
  4. Right-click the feature class and click Show Form.
  5. On the Feature Class Form Toolbar, click . Click Import > Excel Import.

To update data using Excel

  1. In the Maintenance workspace, open an industry model drawing or an enterprise industry model project.
  2. Open the Excel file.
  3. Mark the key column headings to use in the WHERE clause with the pound sign (#).
  4. In the Industry Model explorer, select the feature class to update.
  5. Right-click the feature class and click Show Form.
  6. On the Feature Class Form Toolbar, click . Click Import > Excel Update (Direct)