Understand Data Linking and Matching

Link an Excel Spreadsheet to Access Data

Output Extracted Data

 

Share Data Between Drawings and Applications > Extract Data from Drawings and Spreadsheets > Link an Excel Spreadsheet to Access Data > 

Data Matching Validation

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

Concept

Quick Reference

The data matching validation process fails when it cannot find a valid match between the drawing data and external data (spreadsheet). The following error messages will display:

No match was found between any values in the drawing data and external data.

• If the problem is not resolved, the external data will not be merged. Compare the spreadsheet column data to the drawing data column for any matching values. For example, the numerical data in the drawing data may be set to a different precision level than in the external data.

The data column in the external data does not contain unique values.

• The data in the external data column contains one or more cells that contain identical data. This condition makes it so that one match cannot be configured between the drawing data and the external data.