Import Data from Excel to Master Data Services (MDS Add-in for Excel)
Applies To: SQL Server 2016
In the Master Data ServicesAdd-in for Excel, publish data to the MDS repository when you are finished working in Excel and want to save your changes so other users have access to them.
To perform this procedure:
You must have permission to access the Explorer functional area.
The active worksheet must contain MDS-managed data and you must have made changes or additions to the MDS-managed data.
If you are adding members, you do not have to specify a Code value if codes for the entity are being automatically generated. For more information, see Automatic Code Creation (Master Data Services).
In the Publish and Validate group, click Publish.
Optional. If the Publish and Annotate dialog box is displayed, choose to share the same annotation (comment) for all updates, or to annotate each change individually.
Optional. Select the Do not show this dialog box again check box. You can always show the dialog box in the future by choosing Settings and selecting the Show Publish and Annotate dialog box when publishing check box.