Organize and Refine the Extracted Data

Extract Data Using the Data Extraction Wizard

Link an Excel Spreadsheet to Access Data

 

Share Data Between Drawings and Applications > Extract Data from Drawings and Spreadsheets > Extract Data Using the Data Extraction Wizard > 

Organize and Refine the Extracted Data

Expand All Expand all collapsed sections. Collapse All Collapse all expanded sections.

Concept

Procedure

Quick Reference

To display the sum of numerical data in identical property rows

1. Click Insert tab Linking & Extraction panel Extract Data.At the Command prompt, enter dataextraction
2. In the Data Extraction wizard on the Refine Data page, click Combine Identical Rows.
3. Right-click the column label. Click Combine Record Mode Sum Values.

   The sum of the numerical data is displayed.

 Toolbar: Modify II 

 Command entry: DATAEXTRACTION