<div>
Sounds like you either need the Master Data Services Add in for Excel.<br />
<br />
Have a look at <a href="http://msdn.microsoft.com/en-us/library/hh231024.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/hh231024.aspx</a>&nbsp;for more information.<br />
<br />
Alternatively, full information is also available in the official Microsoft 70-463 exam guide, chapters 14-17 and 20.
</div>


Sounds like you either need the Master Data Services Add in for Excel.

Have a look at http://msdn.microsoft.com/en-us/library/hh231024.aspx [http://msdn.microsoft.com/en-us/library/hh231024.aspx] for more information.

Alternatively, full information is also available in the official Microsoft 70-463 exam guide, chapters 14-17 and 20.

<div>
Not a great way of editing data but you can load the data in a sheet including the primary key column (ID). Make the ID column read only and let the user make other changes. Then you can loop through rows, if ID exists, update the record, if ID is empty, insert the row, if ID is missing, delete the row.
</div>


Not a great way of editing data but you can load the data in a sheet including the primary key column (ID). Make the ID column read only and let the user make other changes. Then you can loop through rows, if ID exists, update the record, if ID is empty, insert the row, if ID is missing, delete the row.

<div>
I forgot to mention that the table sizes are several million at a time
</div>


I forgot to mention that the table sizes are several million at a time

<div>
Thanks but I am specifically looking to build this myself
</div>


Thanks but I am specifically looking to build this myself

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I have been asked to build an Excel Add-in where users can clean up data that resides in a SQL database using Excel.<br />
I need some advice on the best way to go around this. I have already looked at ways to pull a limited set of records through. Now I want to develop ways to use Excel and SQL to alter data effectively
</div>
</div>


Hi

I have been asked to build an Excel Add-in where users can clean up data that resides in a SQL database using Excel.
I need some advice on the best way to go around this. I have already looked at ways to pull a limited set of records through. Now I want to develop ways to use Excel and SQL to alter data effectively

VB.net  Excel Add-in SQL Data Cleansing tool

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.