I need to update a table with new and revised data from in an excel worksheet. I imported the sheet into a new table and now want to compare the old and new tables to merge and add new records to the old table. I couldn't find any way to do it using SQL DataCompare. Am I missing something? It would actually be cooler if I had a way of specifying the excel sheet as the left side database.
Comments
1 comment
-
Thanks for your post.
We have an article explaining the scenario you asked for: http://documentation.red-gate.com/displ ... e+database
Let me know if this helps.
Add comment
Please sign in to leave a comment.