hello guys i have a small requirement.
i have data in Excel Sheet and in Sql server need to compare data for differences and changes, i am asked to create a master data in Excel so i took all the account id from excel and DataHub and created a master account ID but instead of copy paste i need to automate it which i am not aware how to achieve.? so that it automates automatically !!! Thank YOU
You might be able to compare the two using blending, have you tried that approach?